2200 |
How can I delete the selected items (including descendants)
/*begin event KeyDown(integer KeyCode,integer Shift) - Occurs when the user presses a key while an object has the focus.*/ /* oG2antt = ole_1.Object oG2antt.RemoveSelection() */ /*end event KeyDown*/ OleObject oG2antt,var_Chart,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.SingleSel = false oG2antt.Columns.Add("Tasks") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = 2017-08-01 var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,128) var_Chart.SelBackColor = RGB(240,240,240) var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",2017-08-02,2017-08-06) h = var_Items.AddItem("Task 2") var_Items.AddBar(h,"Task",2017-08-03,2017-08-09) var_Items.SelectItem(h,true) h = var_Items.AddItem("Task 3") var_Items.AddBar(h,"Task",2017-08-04,2017-08-13,"") var_Items.SelectItem(h,true) var_Items.AddBar(var_Items.AddItem("Task 4"),"Task",2017-08-05,2017-08-16) oG2antt.EndUpdate() |
2199 |
Dark mode
OleObject oG2antt,var_Chart any back,fore oG2antt = ole_1.Object oG2antt.BeginUpdate() back = 65536 fore = 16777215 oG2antt.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABXUIQAAYAQGKIcBiAKBQAGYBIJDEMgzDDAUBjKKocQTC4AIQjCK4JDKHYJRpHEZyCA8EhqGASRAFUQBYiWE4oSpLABQaK0ZwIGyRIrkGQgQgmPYDSDNU4zVIEEglBI0TDNczhNDENgtGYaJqHIYpZBcM40TKkEZoSIITZcRrOEBiRL1S0RBhGcRUHZlWzdN64LhuK47UrWdD/XhdVzXRbjfz1Oq+bxve48Br7A5yYThdr4LhOFQ3RjIL4xbIcUwGe6VZhjOLZXjmO49T69HTtOCYBEBA") oG2antt.VisualAppearance.Add(2,"gBFLBCJwBAEHhEJAAEhABPMIQAAYAQGKIcBiAKBQAGaAoDDcMgwQwAAxjIKUEwsACEIrjKCYVgOHYYQjGMZwHCMIhiGwcAChEZYHgkMYmDAMUhSE78axHG6PY7kKZ4biaKIqQLLEhSfJ0YyBECBZpfebIbjmIZMSLEIxDKItJSpCIaRgqWS6ahGO4JUbUFLQHT9IR4daIYRgEEBA") oG2antt.VisualAppearance.Add(3,"gBFLBCJwBAEHhEJAAEhABUUIQAAYAQGKIcBiAKBQAGaAoDDcMgwQwAAxjIKUEwsACEIrjKCYVgOHYYQjGMZwGAsEwjAoYAChEaILgkMw2DBIQwgJIMEr/G6RZxjeL5CjmG4nDhKMpybAcXxjBIYZJgOQpXb+PobTrNNLzfRFAxVAaWJikcZ4HpIAJNVLFdQ0XYMNSBISsBqrKiKcpeIIDWBZMbRZT1ZABCIZBpEW6LahENQwXrCN74DYkNTdKaxbbuaaXLhGCYBgIA==") oG2antt.HeaderAppearance = 5 oG2antt.BackColor = back oG2antt.BackColorHeader = back oG2antt.BackColorLevelHeader = back oG2antt.BackColorSortBar = back oG2antt.BackColorSortBarCaption = back oG2antt.FilterBarBackColor = back oG2antt.FilterBarForeColor = fore oG2antt.ForeColor = fore oG2antt.ForeColorHeader = fore oG2antt.ForeColorSortBar = fore oG2antt.SelBackColor = fore oG2antt.SelForeColor = back oG2antt.Background(0,16777216 /*0x1000000*/) oG2antt.Background(18,33554432 /*0x2000000*/) oG2antt.Background(32,-1) oG2antt.Background(64,50331648 /*0x3000000*/) oG2antt.Background(65,back) oG2antt.Background(66,fore) oG2antt.Background(20,fore) oG2antt.Background(21,back) oG2antt.Background(26,back) oG2antt.Background(27,fore) oG2antt.Background(28,back) oG2antt.Background(142,33554432 /*0x2000000*/) oG2antt.Background(141,33554432 /*0x2000000*/) oG2antt.Background(186,fore) oG2antt.Background(511,back) oG2antt.Description(25,"<bgcolor 0><fgcolor ffffff> Exclude </fgcolor></bgcolor>") var_Chart = oG2antt.Chart var_Chart.BackColor = back var_Chart.BackColorLevelHeader = back var_Chart.ForeColor = fore var_Chart.ForeColorLevelHeader = fore oG2antt.EndUpdate() |
2198 |
I have changed the font, but the item's height remains the same. What I am doing wrong
OleObject oG2antt oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = false oG2antt.LoadXML("http://www.exontrol.net/testing.xml") oG2antt.Font.Size = 22 oG2antt.HeaderHeight = 42 oG2antt.DefaultItemHeight = 36 oG2antt.Items.ItemHeight(0,oG2antt.DefaultItemHeight) oG2antt.Chart.UnitWidth = oG2antt.DefaultItemHeight oG2antt.Chart.UnitScale = oG2antt.Chart.UnitScale oG2antt.Chart.Bars.Item("Task").Height = 18 oG2antt.EndUpdate() |
2197 |
I have changed from Project Summary Task to own task created with EBN to get a black frame then using different colors for project status. How can I enlarge the EBN being applied to the head-arrows shows the start/end margins of the range
/*begin event AddGroupItem(long Item) - Occurs after a new Group Item has been inserted to Items collection.*/ /* OleObject var_Items oG2antt = ole_1.Object var_Items = oG2antt.Items var_Items.ItemBold(Item,true) var_Items.AddBar(Item,var_Items.CellValue(Item,var_Items.GroupItem(Item)),2017-12-02,2017-12-02) var_Items.DefineSummaryBars(Item,"",-3,"") */ /*end event AddGroupItem*/ /*begin event AddItem(long Item) - Occurs after a new Item has been inserted to Items collection.*/ /* oG2antt = ole_1.Object oG2antt.Items.AddBar(Item,"Task",2017-12-04,2017-12-10) */ /*end event AddItem*/ OleObject oG2antt,var_Appearance,var_Chart,var_Columns,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() var_Appearance = oG2antt.VisualAppearance var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABN0GACAADACAxRDgMQBQKAAzQFAYbBuGCGAAGIYBTgmFgAQhFcZQSKUOQTDKNYykCQBQAWCQ1DAJIqjOAkEhiGCUQClYYZBjWG4dQLOEYTNC8WwHCIZBpEWgKChGKAlSANMjTZLkdR1ECmIhoSg4coKMoERBJco1BDdOQGAyEQShEC4fgmVwAP7aNoWVC1JynM6XaKmGbJAA6CZgQKGFh2LAdTzSf61cAtWpaUjmRZaYSAFDxpiCYpfQjdUB2JDVfTVP6LbawS4KZgOR5eRboETYeAFcSZGrNMKEXLLSyudKRRreWQaPpGCZTRSUdZxSrbBhvEqlbRNMhwSBEEigNIxToOU4jFgeCROQwQRK9BBoG0CQUEIdhAAyJJvjUeZdmmb5+C8HhiAeZJznoPQ+EgT4rlua4BjCfg+k8d5TkUCZ4w+fxfB+X5xn4fheGebZoH8X53koAR9CASAWAUfofjgJgKH+IJHnGcIDmER5iBEeZgmgVgLgGYYYGoFRTCGaIGAYRYiCiFgmgmYQEF4KIKmKSBRBqCxjAiRgvgwYxIiGQYNmOCJlDUOpeAQBCAg=") var_Appearance.Add(2,"CP:1 -6 0 6 0") var_Chart = oG2antt.Chart var_Chart.LevelCount = 2 var_Chart.FirstVisibleDate = 2017-12-02 var_Chart.PaneWidth(false,342) var_Chart.Bars.Add("S1").Color = 16777216 /*0x1000000*/ var_Chart.Bars.Add("S2").Color = 50266112 /*0x2ff0000*/ var_Columns = oG2antt.Columns var_Columns.Add("C1") var_Columns.Add("C2").AllowSort = false oG2antt.SingleSort = false oG2antt.AllowGroupBy = true oG2antt.HeaderVisible = 1 oG2antt.HeaderAppearance = 1 var_Items = oG2antt.Items var_Items.CellValue(var_Items.AddItem("S1"),1,"SubItem A.1") var_Items.CellValue(var_Items.AddItem("S1"),1,"SubItem A.1") var_Items.CellValue(var_Items.AddItem("S2"),1,"SubItem B.1") var_Items.CellValue(var_Items.AddItem("S2"),1,"SubItem B.1") oG2antt.Layout = "MultipleSort = " + CHAR(34) + "C0:2" + CHAR(34) + "" oG2antt.EndUpdate() |
2196 |
How can I specify the cell's outline, border or lines around, when the cell gets selected
OleObject oG2antt,var_Appearance,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.AttachTemplate("handle AddColumn(Column){Column{Def(48)=4;Def(49)=4;}}") var_Appearance = oG2antt.VisualAppearance var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABPEGACAADACAxRDgMQBQKAAzQFAYbBuGCGAAGIYBTgmFgAQhFcZQSpEEg7BKMYwjOJgFgmEQxDANIBQSKoaQiGQYYLhEZAEiONoaDJCM4wHIMQxHCKTZRkGcfaRCGSfIzpGKpVgOTYiTbPcIyQKtBxDIydJTmeQQQhsFIJU7SdVUPDUJZlWbLAwWTAYazXCKRZBpeJqdo6Y5RUDKUqSdLUYyvEq7ZqnOIpw5vICpaCqOp6HqKFpiXSAFL1fLmAwvPKrJjoeqpWpyCaRZQAGg4dbEdTNNCIbatQANKrCSpgZ7sMB6Di2L4TPS2awoWgRYyTFZMbBAeQ7LC1c45Fqrd4zS4dSxKCahcLxFiaNpYZYnjUap1jGPJlkuAgAkidB3nceZsCQEQJCgGhMGcQ4pkiSxEAAOYpiQIhvkYNA2gSCg5n+LIoGILowFyXQoAYAoAmASAWAaAZgggJgKF2T54DYDoDmECBGBKBJgGgTgWgWYRoFYGIGmGOBqByB5hCgegggiYJYgoJIICIaIeByChixULILGGGAWDCCgjCiTgrg0YxojoC4OmOSJ2D6D5kAgJLFgABAEICA=") var_Appearance.Add(2,"CP:1 -4 0 0 0") oG2antt.SelBackColor = 33554432 /*0x2000000*/ oG2antt.SelForeColor = RGB(0,0,1) oG2antt.FullRowSelect = 0 oG2antt.ShowFocusRect = false oG2antt.DefaultItemHeight = 24 oG2antt.HeaderHeight = 24 oG2antt.DrawGridLines = 2 oG2antt.Columns.Add("C1") oG2antt.Columns.Add("C2") var_Items = oG2antt.Items var_Items.CellValue(var_Items.AddItem("Cell 1"),1,"Cell 2") var_Items.CellValue(var_Items.AddItem("Cell 3"),1,"Cell 4") oG2antt.Items.SelectPos = 1 oG2antt.SelectColumnIndex = 1 oG2antt.EndUpdate() |
2195 |
How can I specify the cell's outline, border or lines around, when the item gets selected
OleObject oG2antt,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.AttachTemplate("handle AddColumn(Column){Column{Def(48)=4;Def(49)=4;}}") oG2antt.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABPEGACAADACAxRDgMQBQKAAzQFAYbBuGCGAAGIYBTgmFgAQhFcZQSpEEg7BKMYwjOJgFgmEQxDANIBQSKoaQiGQYYLhEZAEiONoaDJCM4wHIMQxHCKTZRkGcfaRCGSfIzpGKpVgOTYiTbPcIyQKtBxDIydJTmeQQQhsFIJU7SdVUPDUJZlWbLAwWTAYazXCKRZBpeJqdo6Y5RUDKUqSdLUYyvEq7ZqnOIpw5vICpaCqOp6HqKFpiXSAFL1fLmAwvPKrJjoeqpWpyCaRZQAGg4dbEdTNNCIbatQANKrCSpgZ7sMB6Di2L4TPS2awoWgRYyTFZMbBAeQ7LC1c45Fqrd4zS4dSxKCahcLxFiaNpYZYnjUap1jGPJlkuAgAkidB3nceZsCQEQJCgGhMGcQ4pkiSxEAAOYpiQIhvkYNA2gSCg5n+LIoGILowFyXQoAYAoAmASAWAaAZgggJgKF2T54DYDoDmECBGBKBJgGgTgWgWYRoFYGIGmGOBqByB5hCgegggiYJYgoJIICIaIeByChixULILGGGAWDCCgjCiTgrg0YxojoC4OmOSJ2D6D5kAgJLFgABAEICA=") oG2antt.SelBackColor = 16777216 /*0x1000000*/ oG2antt.SelForeColor = RGB(0,0,1) oG2antt.ShowFocusRect = false oG2antt.DefaultItemHeight = 24 oG2antt.HeaderHeight = 24 oG2antt.DrawGridLines = 2 oG2antt.Columns.Add("C1") oG2antt.Columns.Add("C2") var_Items = oG2antt.Items var_Items.CellValue(var_Items.AddItem("Cell 1"),1,"Cell 2") var_Items.CellValue(var_Items.AddItem("Cell 3"),1,"Cell 4") var_Items.SelectPos = 1 oG2antt.EndUpdate() |
2194 |
How can I specify the cell's outline, border or lines around
OleObject oG2antt,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.AttachTemplate("handle AddColumn(Column){Column{Def(48)=4;Def(49)=4;}}") oG2antt.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABPEGACAADACAxRDgMQBQKAAzQFAYbBuGCGAAGIYBTgmFgAQhFcZQSpEEg7BKMYwjOJgFgmEQxDANIBQSKoaQiGQYYLhEZAEiONoaDJCM4wHIMQxHCKTZRkGcfaRCGSfIzpGKpVgOTYiTbPcIyQKtBxDIydJTmeQQQhsFIJU7SdVUPDUJZlWbLAwWTAYazXCKRZBpeJqdo6Y5RUDKUqSdLUYyvEq7ZqnOIpw5vICpaCqOp6HqKFpiXSAFL1fLmAwvPKrJjoeqpWpyCaRZQAGg4dbEdTNNCIbatQANKrCSpgZ7sMB6Di2L4TPS2awoWgRYyTFZMbBAeQ7LC1c45Fqrd4zS4dSxKCahcLxFiaNpYZYnjUap1jGPJlkuAgAkidB3nceZsCQEQJCgGhMGcQ4pkiSxEAAOYpiQIhvkYNA2gSCg5n+LIoGILowFyXQoAYAoAmASAWAaAZgggJgKF2T54DYDoDmECBGBKBJgGgTgWgWYRoFYGIGmGOBqByB5hCgegggiYJYgoJIICIaIeByChixULILGGGAWDCCgjCiTgrg0YxojoC4OmOSJ2D6D5kAgJLFgABAEICA=") oG2antt.SelBackMode = 1 oG2antt.ShowFocusRect = false oG2antt.DefaultItemHeight = 24 oG2antt.HeaderHeight = 24 oG2antt.DrawGridLines = 2 oG2antt.Columns.Add("C1") oG2antt.Columns.Add("C2") var_Items = oG2antt.Items var_Items.CellValue(var_Items.AddItem("Cell 1"),1,"Cell 2") h = var_Items.AddItem("Cell 2") var_Items.CellValue(h,1,"Cell 3") var_Items.CellBackColor(h,1,16777216 /*0x1000000*/) oG2antt.EndUpdate() |
2193 |
Is it possible to highligth the match while a filter is applied
/*begin event AddColumn(oleobject Column) - Fired after a new column has been added.*/ /* Column.Def(17) = 1 oG2antt = ole_1.Object */ /*end event AddColumn*/ /*begin event FilterChange() - Occurs when the filter was changed.*/ /* any format oG2antt = ole_1.Object format = oG2antt.FormatABC("`value replace '` + value + `' with '<bgcolor 000000><fgcolor FFFFFF>` + value + `</fgcolor></bgcolor>'`",oG2antt.FilterBarPromptPattern) oG2antt.Columns.Item(0).FormatColumn = String(format) oG2antt.Columns.Item(1).FormatColumn = String(format) */ /*end event FilterChange*/ OleObject oG2antt,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.DrawGridLines = 2 oG2antt.HeaderAppearance = 4 oG2antt.Columns.Add("Col 1") oG2antt.Columns.Add("Col 2") var_Items = oG2antt.Items var_Items.CellValue(var_Items.AddItem("219 Smith"),1,"Ignacio 1234") var_Items.CellValue(var_Items.AddItem("1666 County Road 309A"),1,"897 Manassa") var_Items.CellValue(var_Items.AddItem("38 Lone Pine"),1,"Durango 11") var_Items.CellValue(var_Items.AddItem("612 Jachim Street"),1,"Lamar 222") oG2antt.FilterBarPromptPattern = "1" oG2antt.FilterBarPromptVisible = 2067 /*exFilterBarCompact | exFilterBarSingleLine | exFilterBarVisible | exFilterBarPromptVisible*/ oG2antt.FilterBarPromptType = 257 /*exFilterPromptCaseSensitive | exFilterPromptContainsAll*/ oG2antt.EndUpdate() |
2192 |
How can I display the total/sum/aggregate in the same column, when the user groups by a column
/*begin event AddColumn(oleobject Column) - Fired after a new column has been added.*/ /* oG2antt = ole_1.Object */ /*end event AddColumn*/ /*begin event AddGroupItem(long Item) - Occurs after a new Group Item has been inserted to Items collection.*/ /* OleObject var_Items oG2antt = ole_1.Object var_Items = oG2antt.Items var_Items.ItemDivider(Item,-1) var_Items.ItemBackColor(Item,oG2antt.BackColorSortBar) var_Items.ItemHeight(Item,oG2antt.HeaderHeight) var_Items.CellMerge(Item,0,"1,2,3,4,5,7,8,9,10,11,12") var_Items.CellValue(Item,13,"count(current,rec,1)") var_Items.CellValueFormat(Item,13,5 /*exTotalField | exHTML*/) var_Items.CellValue(Item,0,var_Items.CellCaption(Item,var_Items.GroupItem(Item))) var_Items.FormatCell(Item,0,"`<b>` + value + `</b> <font ;7><off 3><fgcolor=808080>(` + %13 + `)`") var_Items.CellValue(Item,6,"sum(current,all,dbl(%6))") var_Items.CellValueFormat(Item,6,5 /*exTotalField | exHTML*/) var_Items.CellForeColor(Item,6,RGB(102,102,102)) */ /*end event AddGroupItem*/ /*begin event Change(long Item,long ColIndex,any NewValue) - Occurs when the user changes the cell's content.*/ /* oG2antt = ole_1.Object oG2antt.Refresh() */ /*end event Change*/ OleObject oG2antt,rs,var_Column,var_Column1,var_Columns,var_Items any hL oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.LinesAtRoot = 5 oG2antt.Indent = 12 oG2antt.ColumnAutoResize = false oG2antt.ScrollBySingleLine = true oG2antt.BackColorSortBar = RGB(240,240,240) oG2antt.AutoDrag = 16 rs = CREATE OLEObject rs.ConnectToNewObject("ADOR.Recordset") rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExG2antt\Sample\Access\misc.accdb",3,3) oG2antt.DataSource = rs oG2antt.SingleSort = false oG2antt.SortBarVisible = true oG2antt.AllowGroupBy = true oG2antt.HeaderHeight = 24 var_Columns = oG2antt.Columns var_Columns.Add("Count").Visible = false var_Column = var_Columns.Item("Freight") var_Column.Def(4,oG2antt.BackColorSortBar) var_Column.Def(7,var_Column.Def(4)) var_Column.Def(49,4) var_Column.Def(48,4) var_Column.HeaderBold = true var_Column.AllowGroupBy = false var_Column.FormatColumn = "value format ``" var_Column.Alignment = 2 var_Column1 = var_Columns.Item(0) var_Column1.AllowGroupBy = false var_Column1.Def(17,1) var_Columns.Item("ShipCountry").SortOrder = 1 oG2antt.ScrollBySingleLine = false var_Items = oG2antt.Items var_Items.LockedItemCount(2,1) hL = var_Items.LockedItem(2,0) var_Items.ItemHeight(hL,24) var_Items.ItemBold(hL,true) var_Items.ItemBackColor(hL,oG2antt.BackColorSortBar) var_Items.CellValue(hL,6,"sum(all,rec,dbl(%6))") var_Items.CellValueFormat(hL,6,5 /*exTotalField | exHTML*/) var_Items.CellHAlignment(hL,6,2) var_Items.FormatCell(hL,6,"value format ``") oG2antt.EndUpdate() |
2191 |
How do I add a total field locked at the bottom of the control
/*begin event AddGroupItem(long Item) - Occurs after a new Group Item has been inserted to Items collection.*/ /* OleObject var_Items oG2antt = ole_1.Object var_Items = oG2antt.Items var_Items.ItemDividerLine(Item,0) var_Items.FormatCell(Item,var_Items.GroupItem(Item),"value + ` Min: <b>` + %13 + `</b> Max: <b>` + %14 + `</b> Sum: <b>` + %15 + `</b>, of Freight column`") var_Items.CellValue(Item,"Min","min(current,all,dbl(%6))") var_Items.CellValueFormat(Item,"Min",4) var_Items.CellValue(Item,"Max","max(current,all,dbl(%6))") var_Items.CellValueFormat(Item,"Max",4) var_Items.CellValue(Item,"Sum","sum(current,all,dbl(%6))") var_Items.CellValueFormat(Item,"Sum",4) var_Items.ItemBackColor(Item,RGB(240,240,240)) */ /*end event AddGroupItem*/ /*begin event Change(long Item,long ColIndex,any NewValue) - Occurs when the user changes the cell's content.*/ /* oG2antt = ole_1.Object oG2antt.Refresh() */ /*end event Change*/ OleObject oG2antt,rs,var_Column,var_Column1,var_Column2,var_Columns,var_Items any hL oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.HasLines = 0 oG2antt.Description(26,"Show/Hide") oG2antt.ColumnsFloatBarSortOrder = 1 oG2antt.ColumnsFloatBarVisible = 2 oG2antt.ColumnAutoResize = false oG2antt.BackColorSortBar = RGB(240,240,240) rs = CREATE OLEObject rs.ConnectToNewObject("ADOR.Recordset") rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExG2antt\Sample\Access\misc.accdb",3,3) oG2antt.DataSource = rs oG2antt.SingleSort = false oG2antt.SortBarVisible = true oG2antt.AllowGroupBy = true oG2antt.SortBarCaption = "Drag a <b>column</b> header here to group by that column." var_Columns = oG2antt.Columns var_Column = var_Columns.Add("Min") var_Column.Visible = false var_Column.AllowDragging = false var_Column = var_Columns.Add("Max") var_Column.Visible = false var_Column.Visible = false var_Column.AllowDragging = false var_Column1 = var_Columns.Add("Sum") var_Column1.Visible = false var_Column1.Visible = false var_Column1.AllowDragging = false var_Column2 = oG2antt.Columns.Item("Freight") var_Column2.FormatColumn = "currency(value)" var_Column2.Def(4,12895487) var_Column2.Def(7,var_Column2.Def(4)) var_Column2.HeaderBold = true var_Column2.AllowGroupBy = false var_Column2.Alignment = 2 oG2antt.ScrollBySingleLine = false var_Items = oG2antt.Items var_Items.LockedItemCount(2,2) hL = var_Items.LockedItem(2,0) var_Items.ItemDivider(hL,0) var_Items.ItemHeight(hL,3) var_Items.ItemDividerLineAlignment(hL,2) var_Items.ItemDividerLine(hL,2) hL = var_Items.LockedItem(2,1) var_Items.CellValue(hL,6,"sum(all,rec,dbl(%6))") var_Items.CellValueFormat(hL,6,4) var_Items.ItemHeight(hL,24) var_Items.ItemBold(hL,true) oG2antt.Columns.Item("EmployeeID").SortOrder = true oG2antt.EndUpdate() |
2190 |
How can I add a total field, when I use grouping
/*begin event AddGroupItem(long Item) - Occurs after a new Group Item has been inserted to Items collection.*/ /* OleObject var_Items oG2antt = ole_1.Object var_Items = oG2antt.Items var_Items.ItemDividerLine(Item,0) var_Items.FormatCell(Item,var_Items.GroupItem(Item),"value + ` Min: <b>` + %13 + `</b> Max: <b>` + %14 + `</b> Sum: <b>` + %15 + `</b>, of Freight column`") var_Items.CellValue(Item,"Min","min(current,all,dbl(%6))") var_Items.CellValueFormat(Item,"Min",4) var_Items.CellValue(Item,"Max","max(current,all,dbl(%6))") var_Items.CellValueFormat(Item,"Max",4) var_Items.CellValue(Item,"Sum","sum(current,all,dbl(%6))") var_Items.CellValueFormat(Item,"Sum",4) var_Items.ItemBackColor(Item,RGB(240,240,240)) */ /*end event AddGroupItem*/ /*begin event Change(long Item,long ColIndex,any NewValue) - Occurs when the user changes the cell's content.*/ /* oG2antt = ole_1.Object oG2antt.Refresh() */ /*end event Change*/ OleObject oG2antt,rs,var_Column,var_Columns,var_Items any hL oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.HasLines = 0 oG2antt.ColumnAutoResize = false oG2antt.BackColorSortBar = RGB(240,240,240) rs = CREATE OLEObject rs.ConnectToNewObject("ADOR.Recordset") rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExG2antt\Sample\Access\misc.accdb",3,3) oG2antt.DataSource = rs oG2antt.SingleSort = false oG2antt.SortBarVisible = true oG2antt.AllowGroupBy = true oG2antt.Columns.Item(1).SortOrder = true var_Columns = oG2antt.Columns var_Columns.Add("Min").Visible = false var_Columns.Add("Max").Visible = false var_Columns.Add("Sum").Visible = false var_Column = oG2antt.Columns.Item("Freight") var_Column.Def(4,12895487) var_Column.Def(7,var_Column.Def(4)) var_Column.HeaderBold = true var_Column.AllowGroupBy = false oG2antt.ScrollBySingleLine = false var_Items = oG2antt.Items var_Items.LockedItemCount(2,1) hL = var_Items.LockedItem(2,0) var_Items.ItemDivider(hL,0) var_Items.ItemHeight(hL,24) var_Items.ItemDividerLineAlignment(hL,2) var_Items.ItemDividerLine(hL,2) var_Items.CellValue(hL,0,"sum(all,rec,dbl(%6))") var_Items.CellValueFormat(hL,0,5 /*exTotalField | exHTML*/) var_Items.CellHAlignment(hL,0,2) var_Items.FormatCell(hL,0,"'Freight: <bgcolor=FFC4C4> '+(value format ``) + ` `") oG2antt.EndUpdate() |
2189 |
How do I use the ColumnsFloatBarVisible on exColumnsFloatBarVisibleIncludeCheckColumns
|
2188 |
The BackColorAlternate displays each second row with a different background color. The question I have it is possible to apply a different background color for 3rd, 4th, row, and so on
/*begin event LayoutChanged() - Occurs when column's position or column's size is changed.*/ /* oG2antt = ole_1.Object oG2antt.Refresh() */ /*end event LayoutChanged*/ /*begin event Sort() - Fired when the control sorts a column.*/ /* oG2antt = ole_1.Object oG2antt.Refresh() */ /*end event Sort*/ OleObject oG2antt,rs,var_Column oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.HasLines = 0 oG2antt.ColumnAutoResize = false rs = CREATE OLEObject rs.ConnectToNewObject("ADOR.Recordset") rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExG2antt\Sample\Access\misc.accdb",3,3) oG2antt.DataSource = rs var_Column = oG2antt.Columns.Add("Position") var_Column.FormatColumn = "1 apos ''" var_Column.Visible = false oG2antt.ConditionalFormats.Add("(%C13 mod 4) = 0").BackColor = RGB(240,240,240) oG2antt.EndUpdate() |
2187 |
The BackColorAlternate looks fine for flat tables, but how about using it when displaying a hierarchy/tree, like grouping rows. The sample alternate colors for each group found
/*begin event LayoutChanged() - Occurs when column's position or column's size is changed.*/ /* oG2antt = ole_1.Object oG2antt.Refresh() */ /*end event LayoutChanged*/ OleObject oG2antt,rs,var_Column oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.HasLines = 0 oG2antt.ColumnAutoResize = false rs = CREATE OLEObject rs.ConnectToNewObject("ADOR.Recordset") rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExG2antt\Sample\Access\misc.accdb",3,3) oG2antt.DataSource = rs oG2antt.SingleSort = false oG2antt.SortBarVisible = true oG2antt.AllowGroupBy = true oG2antt.Columns.Item(1).SortOrder = true var_Column = oG2antt.Columns.Add("Position") var_Column.FormatColumn = "(0:= (1 rpos '')) left ( ( 1:= ( =:0 lfind `.` ) ) != -1 ? =:1 : len(=:0))" var_Column.Visible = false oG2antt.ConditionalFormats.Add("(%C13 mod 2) != 0").BackColor = RGB(240,240,240) oG2antt.EndUpdate() |
2186 |
I need to display sub-totals in the grouping items. Is there any solution on this
/*begin event AddGroupItem(long Item) - Occurs after a new Group Item has been inserted to Items collection.*/ /* OleObject var_Items oG2antt = ole_1.Object var_Items = oG2antt.Items var_Items.ItemDivider(Item,-1) var_Items.EnableItem(Item,false) var_Items.CellValueFormat(Item,oG2antt.TreeColumnIndex,1) var_Items.FormatCell(Item,oG2antt.TreeColumnIndex,"%1") var_Items.CellValueFormat(Item,"Freight",5 /*exTotalField | exHTML*/) var_Items.CellValue(Item,"Freight","sum(current,dir,%6)") var_Items.FormatCell(Item,"Freight","`<b>` + currency(value)") */ /*end event AddGroupItem*/ OleObject oG2antt,rs oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.SelBackMode = 1 oG2antt.BackColorSortBar = RGB(240,240,240) oG2antt.ColumnAutoResize = false rs = CREATE OLEObject rs.ConnectToNewObject("ADOR.Recordset") rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExG2antt\Sample\Access\misc.accdb",3,3) oG2antt.DataSource = rs oG2antt.SortBarVisible = true oG2antt.SortBarCaption = "Drag a <b>column</b> header here to group by that column." oG2antt.AllowGroupBy = true oG2antt.Columns.Item(1).SortOrder = 1 oG2antt.LinesAtRoot = 5 oG2antt.Columns.Item("ShipVia").DisplayFilterButton = true oG2antt.EndUpdate() |
2185 |
I use a subtotal in exTop-Item, after grouping the item shows 0. What is the solution
OleObject oG2antt,rs,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = false rs = CREATE OLEObject rs.ConnectToNewObject("ADOR.Recordset") rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExG2antt\Sample\Access\misc.accdb",3,3) oG2antt.DataSource = rs oG2antt.SingleSort = false oG2antt.AllowGroupBy = true oG2antt.SortBarVisible = true oG2antt.BackColorSortBar = oG2antt.BackColor oG2antt.Columns.Item(5).SortOrder = 1 oG2antt.Columns.Item(6).FormatColumn = "currency(value)" var_Items = oG2antt.Items var_Items.LockedItemCount(0,1) h = var_Items.LockedItem(0,0) var_Items.ItemBackColor(h,RGB(240,240,240)) var_Items.CellBackColor(h,6,RGB(190,190,190)) var_Items.CellValue(h,6,"sum(all,rec,%6)") var_Items.CellValueFormat(h,6,4) oG2antt.Refresh() oG2antt.EndUpdate() |
2184 |
How can I add multiple values/columns on the same line/item/row
/*begin event Change(long Item,long ColIndex,any NewValue) - Occurs when the user changes the cell's content.*/ /* oG2antt = ole_1.Object oG2antt.Refresh() */ /*end event Change*/ OleObject oG2antt,var_Columns,var_Items any h,h1 oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.SortOnClick = 0 oG2antt.LinesAtRoot = 5 oG2antt.Indent = 13 oG2antt.HeaderVisible = false oG2antt.LinesAtRoot = -1 var_Columns = oG2antt.Columns var_Columns.Add("Items") var_Columns.Add("Quantity").Editor.EditType = 4 var_Columns.Add("Value").Editor.EditType = 4 var_Items = oG2antt.Items h = var_Items.AddItem("Items") var_Items.CellValue(h,2,"sum(current,dir,dbl(%1)*dbl(%2))") var_Items.CellValueFormat(h,2,4) var_Items.FormatCell(h,2,"`Total: `+ value") var_Items.CellHAlignment(h,2,2) var_Items.CellBold(h,2,true) var_Items.CellEditorVisible(h,2,false) var_Items.CellEditorVisible(h,1,false) h1 = var_Items.InsertItem(h,,"Item 1") var_Items.CellValue(h1,1,10) var_Items.CellValue(h1,2,3) h1 = var_Items.InsertItem(h,,"Item 2") var_Items.CellValue(h1,1,20) var_Items.CellValue(h1,2,4) var_Items.ExpandItem(h,true) oG2antt.EndUpdate() |
2183 |
Is it possible, to add more aggregate functions to grouping header
/*begin event AddGroupItem(long Item) - Occurs after a new Group Item has been inserted to Items collection.*/ /* OleObject var_Items oG2antt = ole_1.Object var_Items = oG2antt.Items var_Items.FormatCell(Item,var_Items.GroupItem(Item),"value + ` Min: <b>` + %13 + `</b> Max: <b>` + %14 + `</b> Sum: <b>` + %15 + `</b>, of Freight column`") var_Items.CellValue(Item,"Min","min(current,all,dbl(%6))") var_Items.CellValueFormat(Item,"Min",4) var_Items.CellValue(Item,"Max","max(current,all,dbl(%6))") var_Items.CellValueFormat(Item,"Max",4) var_Items.CellValue(Item,"Sum","sum(current,all,dbl(%6))") var_Items.CellValueFormat(Item,"Sum",4) */ /*end event AddGroupItem*/ /*begin event Change(long Item,long ColIndex,any NewValue) - Occurs when the user changes the cell's content.*/ /* oG2antt = ole_1.Object oG2antt.Refresh() */ /*end event Change*/ OleObject oG2antt,rs,var_Columns oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.HasLines = 0 oG2antt.ColumnAutoResize = false rs = CREATE OLEObject rs.ConnectToNewObject("ADOR.Recordset") rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExG2antt\Sample\Access\misc.accdb",3,3) oG2antt.DataSource = rs oG2antt.SingleSort = false oG2antt.SortBarVisible = true oG2antt.AllowGroupBy = true oG2antt.Columns.Item(1).SortOrder = true var_Columns = oG2antt.Columns var_Columns.Add("Min").Visible = false var_Columns.Add("Max").Visible = false var_Columns.Add("Sum").Visible = false oG2antt.EndUpdate() |
2182 |
Is it possible to display more aggregate functions to a single cell (method 2)
/*begin event Change(long Item,long ColIndex,any NewValue) - Occurs when the user changes the cell's content.*/ /* oG2antt = ole_1.Object oG2antt.Refresh() */ /*end event Change*/ OleObject oG2antt,var_Columns,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.SortOnClick = 0 oG2antt.LinesAtRoot = 5 oG2antt.Indent = 13 oG2antt.HeaderVisible = false oG2antt.LinesAtRoot = -1 var_Columns = oG2antt.Columns var_Columns.Add("Items") var_Columns.Add("Quantity").Editor.EditType = 4 var_Columns.Add("Sum").Visible = false var_Columns.Add("Min").Visible = false var_Columns.Add("Max").Visible = false var_Items = oG2antt.Items h = var_Items.AddItem("Items") var_Items.CellMerge(h,0,1) var_Items.FormatCell(h,0,"`Items, <b>sum(` + %2 + `), min(` + %3 + `), max(` + %4 + `)</b>`") var_Items.CellValueFormat(h,0,1) var_Items.CellValue(h,2,"sum(current,dir,dbl(%1))") var_Items.CellValueFormat(h,2,4) var_Items.CellValue(h,3,"min(current,dir,dbl(%1))") var_Items.CellValueFormat(h,3,4) var_Items.CellValue(h,4,"max(current,dir,dbl(%1))") var_Items.CellValueFormat(h,4,4) var_Items.CellValue(var_Items.InsertItem(h,,"Item 1"),1,10) var_Items.CellValue(var_Items.InsertItem(h,,"Item 2"),1,20) var_Items.CellValue(var_Items.InsertItem(h,,"Item 3"),1,30) var_Items.ExpandItem(h,true) oG2antt.EndUpdate() |
2181 |
How can I use the current in the aggregate/total field
/*begin event Change(long Item,long ColIndex,any NewValue) - Occurs when the user changes the cell's content.*/ /* oG2antt = ole_1.Object oG2antt.Refresh() */ /*end event Change*/ OleObject oG2antt,var_Columns,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.SortOnClick = 0 oG2antt.LinesAtRoot = 5 oG2antt.Indent = 13 oG2antt.HeaderVisible = false oG2antt.LinesAtRoot = -1 var_Columns = oG2antt.Columns var_Columns.Add("Items") var_Columns.Add("Quantity").Editor.EditType = 4 var_Items = oG2antt.Items h = var_Items.AddItem("Items") var_Items.CellValue(h,1,"sum(current,dir,dbl(%1))") var_Items.CellValueFormat(h,1,4) var_Items.FormatCell(h,1,"`Total: `+ value") var_Items.CellValue(var_Items.InsertItem(h,,"Item 1"),1,10) var_Items.CellValue(var_Items.InsertItem(h,,"Item 2"),1,20) var_Items.CellValue(var_Items.InsertItem(h,,"Item 3"),1,30) var_Items.ExpandItem(h,true) oG2antt.EndUpdate() |
2180 |
The CellValue/CellCaption property gets the result of a computed/total field with text formatting. Is it possible to get that value without text formatting
OleObject oG2antt,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("A").Editor.EditType = 4 oG2antt.Columns.Add("B").Editor.EditType = 4 oG2antt.Columns.Add("A+B") var_Items = oG2antt.Items h = var_Items.AddItem(10) var_Items.CellValue(h,1,20) var_Items.CellValueFormat(h,2,2) var_Items.CellValue(h,2,"currency(dbl(%0)+dbl(%1))") MessageBox("Information",string( "CellCaption returns " )) MessageBox("Information",string( var_Items.CellCaption(h,2) )) MessageBox("Information",string( "CellValue returns " )) MessageBox("Information",string( String(var_Items.CellValue(h,2)) )) MessageBox("Information",string( "ComputeValue returns " )) MessageBox("Information",string( String(var_Items.ComputeValue("dbl(%0)+dbl(%1)",h,0,var_Items.CellValueFormat(h,2))) )) oG2antt.EndUpdate() |
2179 |
Can I get the result of a specified formula as your control does using the ComputedField property
OleObject oG2antt,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("A") oG2antt.Columns.Add("B") var_Items = oG2antt.Items h = var_Items.AddItem(10) var_Items.CellValue(h,1,20) MessageBox("Information",string( "A+B is " )) MessageBox("Information",string( String(var_Items.ComputeValue("dbl(%0)+dbl(%1)",h,0,2)) )) oG2antt.EndUpdate() |
2178 |
Is it possible to get the text without HTML formatting
OleObject oG2antt,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("") var_Items = oG2antt.Items h = var_Items.AddItem("<b>bold</b>") MessageBox("Information",string( String(var_Items.ComputeValue(var_Items.CellValue(h,0),h,0,1)) )) oG2antt.EndUpdate() |
2177 |
Transparent/Border SummaryBar
/*begin event AddGroupItem(long Item) - Occurs after a new Group Item has been inserted to Items collection.*/ /* OleObject var_Items oG2antt = ole_1.Object var_Items = oG2antt.Items var_Items.ItemDividerLine(Item,0) var_Items.AddBar(Item,"Summary",2017-12-02,2017-12-02) var_Items.DefineSummaryBars(Item,"",-3,"") */ /*end event AddGroupItem*/ /*begin event AddItem(long Item) - Occurs after a new Item has been inserted to Items collection.*/ /* oG2antt = ole_1.Object oG2antt.Items.AddBar(Item,"Task",2017-12-04,2017-12-10) */ /*end event AddItem*/ OleObject oG2antt,var_Bar,var_Bar1,var_Chart,var_Column,var_Columns,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABHEGACAADACAxRDgMQBQKAAzQFAYbBuGCGAAGIYBTgmFgAQhFcZQSKUOQTDKMIziaQJiYLBIaRgEUTRXASCQxDBKQBSeKkRRtDaOYDnGQYDiCIouQLEIxDKItBSJCKURJkAZZHjeToSR5PMb0dKdAw5I6raShEaaIiqJIXP7Fc7QSA0EgTBIFajgOpQAb+bptW7FVDULTMQS5FCZKasOA7FgOZ4DWjUVpwTZ1Q4LC65bjuaraawKbYbXrFYJQSA8EwjNjDcLuKqcKpvDJsSJIFKxOB2KYtBLMLbzLR5apjLZ0QLSOKRDoMEgRDYGdKjLScGrGao8ABtcBlAZJRjoOo5DJgeCQapUQhNczGQzQSIiBOJZAFSQwRHcJhGh2BZvngMIeA8H4TksA5ylgZBeg8X4GmGX4nniPazneQ5VnKdp9H8P4vD+X57nMRofmgBZ4FgIAoBWdoBGAGAeAgfxfjgNZ1DqWxEA0ASAgA==") var_Chart = oG2antt.Chart var_Chart.LevelCount = 2 var_Chart.FirstVisibleDate = 2017-12-02 var_Chart.PaneWidth(false,256) var_Bar = var_Chart.Bars.Item("Summary") var_Bar.Color = 16777216 /*0x1000000*/ var_Bar.Def(3,"<%=%513%>") var_Bar.Def(4,18) var_Bar.Def(58,8) var_Bar1 = var_Chart.Bars.Item("Task") var_Bar1.Pattern = 32 var_Bar1.Color = RGB(0,0,0) var_Columns = oG2antt.Columns var_Columns.Add("C1") var_Columns.Add("C2") var_Column = var_Columns.Add("Pos") var_Column.FormatColumn = "1 pos ``" var_Column.AllowGroupBy = false var_Column.Position = 0 var_Column.Width = 48 var_Column.AllowSizing = false oG2antt.SortBarVisible = true oG2antt.AllowGroupBy = true oG2antt.BackColorSortBar = oG2antt.BackColor oG2antt.HeaderAppearance = 4 var_Items = oG2antt.Items var_Items.CellValue(var_Items.AddItem("Item A"),1,"SubItem A.1") var_Items.CellValue(var_Items.AddItem("Item A"),1,"SubItem A.2") var_Items.CellValue(var_Items.AddItem("Item A"),1,"SubItem A.3") var_Items.CellValue(var_Items.AddItem("Item A"),1,"SubItem A.4") var_Items.CellValue(var_Items.AddItem("Item B"),1,"SubItem B.1") var_Items.CellValue(var_Items.AddItem("Item B"),1,"SubItem B.2") oG2antt.Columns.Item(0).SortOrder = 1 oG2antt.EndUpdate() |
2176 |
The bar's caption is very difficult to read if any pattern than exPatternSolid is used. Is there any way of displaying the bar's caption (except for displaying the caption outside the bar)
OleObject oG2antt,var_Bar,var_Chart,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Font.Size = 12 oG2antt.DefaultItemHeight = 24 oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.LevelCount = 2 var_Chart.FirstVisibleDate = 2001-01-01 var_Bar = var_Chart.Bars.Item("Task") var_Bar.Height = 21 var_Bar.Pattern = 7 var_Chart.PaneWidth(false,128) var_Chart.UnitWidth = 24 var_Items = oG2antt.Items h = var_Items.AddItem("") var_Items.AddBar(h,"Task",2001-01-02,2001-01-06,"") var_Items.ItemBar(h,"",3,"to do") h = var_Items.AddItem("bgcolor") var_Items.AddBar(h,"Task",2001-01-02,2001-01-06,"") var_Items.ItemBar(h,"",3,"<bgcolor=FFFFFF> to do </bgcolor>") h = var_Items.AddItem("fgcolor") var_Items.AddBar(h,"Task",2001-01-02,2001-01-06,"") var_Items.ItemBar(h,"",3,"<fgcolor=FFFFFF> to do </fgcolor>") h = var_Items.AddItem("sha") var_Items.AddBar(h,"Task",2001-01-02,2001-01-06,"") var_Items.ItemBar(h,"",3,"<sha FFFFFF;2;2> to do </sha>") h = var_Items.AddItem("out") var_Items.AddBar(h,"Task",2001-01-02,2001-01-06,"") var_Items.ItemBar(h,"",3,"<out 000000><fgcolor=FFFFFF>to do</fgcolor></out></font>") h = var_Items.AddItem("gra") var_Items.AddBar(h,"Task",2001-01-02,2001-01-06,"") var_Items.ItemBar(h,"",3,"<fgcolor FFFFFF><gra 000000;1;1>to do</fgcolor>") oG2antt.EndUpdate() |
2175 |
How can I change the position of the bar's tooltip
/*begin event ToolTip(long Item,long ColIndex,boolean Visible,long X,long Y,long CX,long CY) - Fired when the control prepares the object's tooltip.*/ /* oG2antt = ole_1.Object MessageBox("Information",string( "ToolTip" )) MessageBox("Information",string( String(Item) )) MessageBox("Information",string( String(ColIndex) )) MessageBox("Information",string( String(Visible) )) MessageBox("Information",string( String(X) )) MessageBox("Information",string( String(Y) )) MessageBox("Information",string( String(CX) )) MessageBox("Information",string( String(CY) )) X = oG2antt.FormatABC("value + 8",X) Y = oG2antt.FormatABC("value - 8",Y) */ /*end event ToolTip*/ OleObject oG2antt,var_Chart,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.PaneWidth(false,64) var_Chart.FirstVisibleDate = 2001-01-01 var_Chart.Bars.Item("Task").Def(6,"<b><%=%9 + '/' + %C0%></b><br><upline><dotline>Start: <%=%1%><br>End: <%=%2%><br>Duration: <%=(%2-%1)%><br>Working: <%=%258%>") var_Chart.LevelCount = 2 var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem("Tasks A"),"Task",2001-01-02,2001-01-04) var_Items.AddBar(var_Items.AddItem("Tasks B"),"Task",2001-01-03,2001-01-08) oG2antt.EndUpdate() |
2174 |
How can I replace the cell's context menu ( while edit mode is running )
/*begin event RClick() - Fired when right mouse button is clicked*/ /* OleObject var_ExContextMenu oG2antt = ole_1.Object MessageBox("Information",string( "Edit Mode: " )) MessageBox("Information",string( String(oG2antt.Editing) )) var_ExContextMenu = CREATE OLEObject var_ExContextMenu.ConnectToNewObject("Exontrol.ContextMenu") var_ExContextMenu.Items.ToString = "Check[chk],[sep],Item 1,Item 2,Item 3,Popup(A,B,C)" MessageBox("Information",string( String(var_ExContextMenu.Select()) )) */ /*end event RClick*/ OleObject oG2antt,var_Editor,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.HeaderAppearance = 1 var_Editor = oG2antt.Columns.Add("Column").Editor var_Editor.EditType = 1 var_Editor.Option(202,false) var_Items = oG2antt.Items var_Items.AddItem("Item 1") var_Items.AddItem("Item 2") oG2antt.EndUpdate() |
2173 |
Is it possible to highlight the column's header once a filter is applied (sample 2)
OleObject oG2antt,var_Appearance,var_Column,var_Columns,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() var_Appearance = oG2antt.VisualAppearance var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABO8GACAADACAxRDgMQBQKAAzQFAYbBuGCGAAGIYBTgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwQgmNYDSBMcbwSAsXRYFocJ5gOT6AjKBA2UclEZpajiTY3ABUEgUS5oOBIACqariaQJAAiCRQGiYZyHKaRSwPBKFYDIIjbJheTIDChNVxUcDENQjJqLBIDRzbarye59YBfeBXdgmA4LQbDMRwNgMMQTDqKYbkOQZHbeGKAWTMEZzJj8cxTEqIaBhGTLfojSZMS7UGK1LLtMyHI6kP7sOiLfi2W4/W7XV72F79TzXIa2ZBuO57bhnAZ/VzGNj4PRNezfRqicjsGxcZwXg+TpQj0ew6gSOw7wSbozjsfYXi8PwMnSc52leHotl+MxjmoXh2nybxOH+SQtnYXx+D2P4vGMB56hQf5PCgBYeDwYBCEo1xggebgKH6IIDBYBgkiAQ5FgYPAhEIRgWGqDBoC4GoCiGCBYhGBQPAWdIQp0eIUiWCZigiJgqgqYpIioJQhmIMhBH0NxjEMag2g2Y4ImYOoOmOSJeDQNxXlOLR3ECUAQICA=") var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABgsHQAAYAQGKIcBiAKBQAGaAoDDYNwwQwAAxDAKcEwsACEIrjKCRShyCYZRrGUgRCKQahLEiTIhGUYJHgmK4tRoAUgxWCEExrAaQJjjeCQFi6LAtDhPMByfQEZQIGyjkgjNLUcSbG4AKgkCiXfpUAJVP7FcgSABEEigNIxToOU4jFgeCYLQKQRK2RC9GQGFCbLhpYKIahGTYWVheN5XXblez9P7ABQwKCcAwXBp7YIKAT4XBIdYdQ7IL4xGA0AJPFoJC7mOQ5XiYAIBAZ/RL0LCcbxHHafVboQj6JouD5PUDVNY1XBdPynI6CbLhWy6Dq4UZzPwzeBifSHfDjRoJcCZe71KY3GwSEboNA6Kp+QBHAmZoZjSPYIEiF47lOLJVnuYofBwJJHmaQoYj0MIRHeM4/m6cJ8B+fpBHQJ5SGKPYYH8OYMk+P5Bn4fxaAYZAvEIX4RgUWBGgCCAmAqApgkgNgOgMEYlGASoEkQeBWBaBZhggZgagaYRoEwShWA6NZZAMQBAICA==") oG2antt.Background(0,16777216 /*0x1000000*/) oG2antt.Background(41,33554432 /*0x2000000*/) oG2antt.Background(32,-1) oG2antt.HeaderHeight = 28 oG2antt.BackColorHeader = RGB(255,255,255) oG2antt.DrawGridLines = -2 oG2antt.HeaderVisible = 1 var_Columns = oG2antt.Columns var_Columns.Add("C1").DisplayFilterButton = true var_Column = var_Columns.Add("C2") var_Column.DisplayFilterButton = true var_Column.Filter = "Item 2" var_Column.FilterType = 240 var_Columns.Add("C3").DisplayFilterButton = true var_Items = oG2antt.Items h = var_Items.AddItem("Item 1") var_Items.CellValue(h,1,"Item 2") var_Items.CellValue(h,2,"Item 3") h = var_Items.AddItem("Item 4") var_Items.CellValue(h,1,"Item 5") var_Items.CellValue(h,2,"Item 6") oG2antt.ApplyFilter() oG2antt.EndUpdate() |
2172 |
How can I make the expand/collapse glyphs DPI aware
OleObject oG2antt,var_Appearance,var_Items any h,size oG2antt = ole_1.Object size = 2 oG2antt.BeginUpdate() var_Appearance = oG2antt.VisualAppearance var_Appearance.Add(3,"gBFLBCJwBAEHhEJAAEhEGAUHQAAYAQGKIcBiAKBQAGaAoDDYOA4QwAAxDAKcEwsACEIrjKCRShyCYZRhGcTSBCIZBqEqSZLiEZRQiiCYsS5GQBRfIUEghGyNZjgNzQcCQAI8T5IUgARBJIDSMY6DpOIxYHgmC4DEITNLxOK0EhRHCBZrgOCAYhqEY1Ro+dhPFYjVTMdK0LRtKy7Mq2aJmOpZDxWE7dZKpO5fbxXS67cr2fp/YBed4rfa7KTlOBKcRQRBEFQPDqPZBkORZHh2FoLRJKbgtHJmHYNQWhVyYBbNCyTI6lahpeuHBx1QaWWxjbCMEr6bpoWLbFi3Ha1UzrPa8b5vSw7Gr+HzYQTHGPXGqaYJdZrnea6B7+U5XUJrnSOZciYHwhAeR5HDK+JVGqKRRmScx5HyfRei+H5bmmcp4Fi8o/CGGJKGQKZUGoFQigUPIiCeSZXnyHB6l0SAJn8JxfkIeZ5CgXxjCCAhyB8QgIlAM4MlKAIcCaIBIGYGoGGEYhqBMMxgnICgRDUDQjESGwmAkWBuCqBoiHIVgkDQYgYESWg2E0YhohcJQigITg3CQSRyEyEYGGOWJwhQJD4FiFIMk0aJFGsIBkkOBJeDc+AchYJwJgIWhSgYZQpFIVoVGOGQ4l2EwIBWMhgDmDhThCEwkAiaJchKDhjhgZhsCUY4iFCEoZkiaYQmSGAWhWQhgDuDpTjCDQiEgchAg0IpJBoDoFiEKBqCaCAimgIguH8IZnkPUhcBcJg+hGJZnloYJsiaKZKGa24YnWSR0CkKhCA2CxlCqColhAYpqEKER0DqVZ0A0ASAgA==") var_Appearance.Add(4,"gBFLBCJwBAEHhEJAAEhABAQCg6AADACAxRDgMQBQKAAzQFAYbBwHCGAAGIYBTgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACjeQYJBCNYbTJAbqhYIgAR3HqQZABCCSQKkYx0HScRiwPBMFwGIQmaaicZoJCiN4DTZAcIBRDUIxpDR9bBeKw3KqVaZnWhaNpWXZlTzKdSxXisF67RZSdi/XgvF5XXblez9P69LwXe5mUrGbyVYghCCIKgeG4dR7IMhyLDcKQXCCVW7aGSsOwbAqAXpdGAXTQdDyLJKnaZqOi6BjjA4rNbHGIYJb1XTRMa1LJuG5LJrOeZ3Xre4BLfh1VoFRpjWIYNY1QS7TLOczzfRdDxTiGVpkjCeJoD4Ng1hSRxiisVRKg8D4PkWZJznmPQ+F8Xx5guWpjHGWYMiYQodEaIRSCgU5KCSeh3naHB/iAAh9n8fwfgIeZ1CgXwjCCAhxl8AgIlAM4MlKAIcCaD54FYFoFmGCBmBaBIJigPJNgKSAoDSVC+BIbIYCUYYoiYKoJgkWIMlGCAglMaJZDWCYiFyFIJkkOJYhEJc7G4PYPCOaJshQJBjgiVIUgyDRokEaggGSQ4El4N1CBiFgnAmAhaFKFZlFkShUhWJRYmITg3GSQgFGuGBOGOFJkCSSQCDoNgkiOCY0hUJJmmmQhvhqZtYmUOQmBWIRvhgTpjjSbAjEiEgchBZgyEaBIhigWgegqIhIjoDILiACB5nTL5WnWRYOiSKYJnqGQ7CmOh2hqJ5OkYORxFyShKhSAxihkOomioY5YiqFIkFyTo1HkAxAEAgIA==") var_Appearance.Add(1,oG2antt.FormatABC("`CP:3 -` + int(value*dpi) + ` -` + int(value*dpi) + ` ` + int(value*dpi) + ` ` + int(value*dpi)",size)) var_Appearance.Add(2,oG2antt.FormatABC("`CP:4 -` + int(value*dpi) + ` -` + int(value*dpi) + ` ` + int(value*dpi) + ` ` + int(value*dpi)",size)) oG2antt.LinesAtRoot = 1 oG2antt.HasButtons = 4 oG2antt.HasButtonsCustom(false,16777216) oG2antt.HasButtonsCustom(true,33554432) oG2antt.Columns.Add("Column") var_Items = oG2antt.Items h = var_Items.AddItem("Root 1") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") var_Items.ExpandItem(h,true) h = var_Items.AddItem("Root 2") var_Items.InsertItem(h,,"Child") oG2antt.EndUpdate() |
2171 |
Is it possible to highlight the column's header once a filter is applied (sample 1)
OleObject oG2antt,var_Appearance,var_Column,var_Columns,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() var_Appearance = oG2antt.VisualAppearance var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgANJ0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8YNYuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4hhKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mgbhOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhWBMJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI=") var_Appearance.Add(1,"CP:2 -8 -4 2 4") oG2antt.Background(0,33488638 /*0x1fefefe*/) oG2antt.Background(41,16843009 /*0x1010101*/) oG2antt.Background(32,-1) oG2antt.HeaderHeight = 28 oG2antt.BackColorHeader = RGB(255,255,255) oG2antt.DrawGridLines = -2 oG2antt.HeaderVisible = 1 var_Columns = oG2antt.Columns var_Columns.Add("C1").DisplayFilterButton = true var_Column = var_Columns.Add("C2") var_Column.DisplayFilterButton = true var_Column.Filter = "Item 2" var_Column.FilterType = 240 var_Columns.Add("C3").DisplayFilterButton = true var_Items = oG2antt.Items h = var_Items.AddItem("Item 1") var_Items.CellValue(h,1,"Item 2") var_Items.CellValue(h,2,"Item 3") h = var_Items.AddItem("Item 4") var_Items.CellValue(h,1,"Item 5") var_Items.CellValue(h,2,"Item 6") oG2antt.ApplyFilter() oG2antt.EndUpdate() |
2170 |
How do I update itemcount and matchitemcount of the FilterBarCaption after I added the item using the AddItem method
/*begin event Click() - Occurs when the user presses and then releases the left mouse button over the tree control.*/ /* oG2antt = ole_1.Object oG2antt.Items.AddItem("new") oG2antt.Refresh() */ /*end event Click*/ OleObject oG2antt,var_Column,var_Column1,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Chart.PaneWidth(true,0) var_Column = oG2antt.Columns.Add("Item") var_Column.DisplayFilterButton = true var_Column.FilterList = 9504 /*exShowExclude | exShowFocusItem | exShowCheckBox | exSortItemsAsc*/ var_Column1 = oG2antt.Columns.Add("Pos") var_Column1.AllowSizing = false var_Column1.AllowSort = false var_Column1.Width = 32 var_Column1.FormatColumn = "1 apos ``" var_Column1.Position = 0 var_Items = oG2antt.Items var_Items.AddItem("Item A") var_Items.AddItem("Item B") var_Items.AddItem("Item C") oG2antt.FilterBarCaption = "`<r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )" oG2antt.FilterBarPromptVisible = 3591 /*exFilterBarCompact | exFilterBarShowCloseOnRight | exFilterBarShowCloseIfRequired | exFilterBarCaptionVisible | exFilterBarVisible | exFilterBarPromptVisible*/ oG2antt.EndUpdate() |
2169 |
The Edit method does not work while ReadOnly property is exLocked and the first column is hidden. Is there any fix
/*begin event DblClick(integer Shift,long X,long Y) - Occurs when the user dblclk the left mouse button over an object.*/ /* any var_ItemFromPoint oG2antt = ole_1.Object var_ItemFromPoint = oG2antt.ItemFromPoint(-1,-1,c,hit) oG2antt.FocusColumnIndex = c oG2antt.Edit() */ /*end event DblClick*/ OleObject oG2antt,var_Column,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Chart.PaneWidth(true,0) oG2antt.HeaderAppearance = 4 oG2antt.AutoEdit = false oG2antt.ReadOnly = 1 oG2antt.AutoSearch = true oG2antt.Columns.Add("").Visible = false var_Column = oG2antt.Columns.Add("Contains") var_Column.AutoSearch = 1 var_Column.Editor.EditType = 1 var_Items = oG2antt.Items var_Items.CellValue(var_Items.AddItem(),1,"Tom Hanks") var_Items.CellValue(var_Items.AddItem(),1,"Leonardo DiCaprio") var_Items.CellValue(var_Items.AddItem(),1,"Will Smith") var_Items.CellValue(var_Items.AddItem(),1,"Tom Cruise") oG2antt.EndUpdate() |
2168 |
How can I highlight the cell's button with a different appearance, when cursor hovers it
OleObject oG2antt,var_Column,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") oG2antt.DefaultItemHeight = 22 oG2antt.TreeColumnIndex = -1 oG2antt.SelForeColor = RGB(0,0,0) oG2antt.SelBackColor = oG2antt.BackColor oG2antt.Background(157,16777216 /*0x1000000*/) var_Column = oG2antt.Columns.Add("Buttons") var_Column.Def(2,true) var_Column.Def(17,1) var_Column.Alignment = 1 var_Column.HeaderAlignment = 1 var_Items = oG2antt.Items var_Items.AddItem("Button <b>1</b>") var_Items.AddItem("Button <b>2</b>") var_Items.AddItem("Button <b>3</b>") oG2antt.EndUpdate() |
2167 |
How to group one or more operations into a block when the user do undo or redo
OleObject oG2antt,var_Chart,var_Items,var_Note any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Tasks") var_Chart = oG2antt.Chart var_Chart.AllowUndoRedo = true var_Chart.FirstVisibleDate = 2005-06-20 var_Chart.AllowLinkBars = true var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,64) var_Chart.Bars.Item("Task").Height = 16 var_Items = oG2antt.Items var_Items.StartBlockUndoRedo() var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",2005-06-23,2005-06-27,"") var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",2005-06-28,2005-07-02,"") var_Items.AddLink("L1",var_Items.ItemByIndex(0),"",var_Items.ItemByIndex(1),"") var_Items.EndBlockUndoRedo() h = var_Items.ItemByIndex(1) var_Note = oG2antt.Chart.Notes.Add("NoteD",h,2005-06-26,"CTRL+Z (undo), CTRL+Y (redo)") var_Note.PartShadow(1,false) var_Note.PartToolTip(1,"Press CTRL+Z to undo <br> and then press CTRL+Y to redo") var_Note.PartTransparency(1,25) var_Note.PartVOffset(1,-2) var_Note.PartBackColor(1,RGB(255,255,0)) oG2antt.EndUpdate() |
2166 |
I am using the Link property to customize the link, but when I press redo it (CTRL+Y) to redo it, not all properties are restored. What can be done
OleObject oG2antt,var_Chart,var_Items any u oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Tasks") var_Chart = oG2antt.Chart var_Chart.AllowUndoRedo = true var_Chart.FirstVisibleDate = 2005-06-20 var_Chart.AllowLinkBars = true var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,64) var_Chart.Bars.Item("Task").Height = 16 var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",2005-06-23,2005-07-01,"") var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",2005-06-27,2005-07-04,"") var_Items.StartBlockUndoRedo() var_Items.AddLink("L1",var_Items.ItemByIndex(0),"",var_Items.ItemByIndex(1),"") u = var_Items.StartUpdateLink("L1") var_Items.Link("L1",10,2) var_Items.Link("L1",12,"<fgcolor FF0000>CTRL+Z (undo), CTRL+Y (redo)") var_Items.Link("L1",13,"Press CTRL+Z to undo <br> and then press CTRL+Y to redo") var_Items.Link("L1",6,0) var_Items.Link("L1",8,255) var_Items.EndUpdateLink(u) var_Items.EndBlockUndoRedo() oG2antt.EndUpdate() |
2165 |
I am using the ItemBar property to customize the task, but when I press redo it (CTRL+Y) to redo it, not all properties are restored. What can be done
OleObject oG2antt,var_Chart,var_Items any h,u oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Tasks") var_Chart = oG2antt.Chart var_Chart.AllowUndoRedo = true var_Chart.FirstVisibleDate = 2005-06-20 var_Chart.AllowLinkBars = true var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,64) var_Chart.Bars.Item("Task").Height = 16 var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",2005-06-21,2005-06-30,"") h = var_Items.AddItem("Task 2") var_Items.StartBlockUndoRedo() var_Items.AddBar(h,"Task",2005-06-27,2005-07-04,"","CTRL+Z (undo), CTRL+Y (redo)") u = var_Items.StartUpdateBar(h,"") var_Items.ItemBar(h,"",33,255) var_Items.ItemBar(h,"",6,"Press CTRL+Z to undo <br> and then press CTRL+Y to redo") var_Items.EndUpdateBar(u) var_Items.EndBlockUndoRedo() oG2antt.EndUpdate() |
2164 |
The incremental search feature is no working for columns with editor assigned. What can be done
/*begin event DblClick(integer Shift,long X,long Y) - Occurs when the user dblclk the left mouse button over an object.*/ /* oG2antt = ole_1.Object oG2antt.Edit() */ /*end event DblClick*/ OleObject oG2antt,var_Column,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Chart.PaneWidth(true,0) oG2antt.HeaderAppearance = 4 oG2antt.AutoEdit = false oG2antt.AutoSearch = true var_Column = oG2antt.Columns.Add("Contains") var_Column.AutoSearch = 1 var_Column.Editor.EditType = 1 var_Items = oG2antt.Items var_Items.AddItem("Tom Hanks") var_Items.AddItem("Leonardo DiCaprio") var_Items.AddItem("Will Smith") var_Items.AddItem("Tom Cruise") oG2antt.EndUpdate() |
2163 |
Each item is representated by a key as string. Is it possible to have a drop down editor to display more information when using the item's key
OleObject oG2antt,var_Editor,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Chart.PaneWidth(true,0) oG2antt.HeaderAppearance = 4 var_Editor = oG2antt.Columns.Add("Multiple-Columns Tree DropDownListType").Editor var_Editor.EditType = 3 var_Editor.AddItem(0,"KR|Korea, Republic of") var_Editor.AddItem(1,"MO|Macao") var_Editor.AddItem(2,"SA|Saudi Arabia") var_Editor.AddItem(3,"EG|Egypt") var_Editor.AddItem(4,"GB|United Kingdom") var_Editor.AddItem(5,"GT|Guatemala") var_Editor.AddItem(6,"SR|Suriname") var_Editor.AddItem(7,"BM|Bermuda") var_Items = oG2antt.Items var_Items.AddItem("EG") var_Items.AddItem("GB") var_Items.AddItem("BM") oG2antt.EndUpdate() |
2162 |
My table includes codes/keys for items, can I display a drop down editor to include more information
OleObject oG2antt,var_Editor,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Chart.PaneWidth(true,0) oG2antt.HeaderAppearance = 4 var_Editor = oG2antt.Columns.Add("Multiple-Columns DropDownListType").Editor var_Editor.EditType = 3 var_Editor.DropDownAutoWidth = 0 var_Editor.Option(57,"City¦Coordinates¦State") var_Editor.AddItem(0,"JV3|Jollyville¦3026N 09746W¦Texas") var_Editor.AddItem(1,"TMO|Altamont¦4021N 11017W¦Utah") var_Editor.AddItem(2,"IIM|Williamston¦4241N 08417W¦Michigan") var_Editor.AddItem(3,"IWN|Merrittstown¦3958N 07952W¦Pennsylvania") var_Editor.AddItem(4,"HOU|Houston¦2945N 09521W¦Texas") var_Editor.AddItem(5,"GSF|Gales Ferry¦4125N 07205W¦Connecticut") var_Items = oG2antt.Items var_Items.AddItem("HOU") var_Items.AddItem("IIM") var_Items.AddItem("TMO") oG2antt.EndUpdate() |
2161 |
How can I display and select from a multiple-columns tree editor
OleObject oG2antt,var_Editor,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Chart.PaneWidth(true,0) oG2antt.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") oG2antt.HeaderAppearance = 4 var_Editor = oG2antt.Columns.Add("Multiple-Columns Tree DropDownListType").Editor var_Editor.EditType = 3 var_Editor.DropDownAutoWidth = 0 var_Editor.Option(57,"Name¦Title¦City¦Phone") var_Editor.Option(58,"224¦¦¦96") var_Editor.AddItem(1,"Nancy Davolio¦Sales Representative¦Seattle¦(206) 555-9857",1) var_Editor.AddItem(2,"Andrew Fuller¦<b>Vice President</b>, Sales¦Tacoma¦(206) 555-9482",2) var_Editor.InsertItem(3,"Janet Leverling¦Sales Representative¦Kirkland¦(206) 555-3412",3,2) var_Editor.InsertItem(4,"Peacock Margaret¦Sales Representative¦Redmond¦(206) 555-8122",3,2) var_Editor.InsertItem(5,"Steven Buchanan¦Sales Manager¦London¦(71) 555-4848",2,2) var_Editor.InsertItem(6,"Michael Suyama¦Sales Representative¦London¦(71) 555-7773",1,5) var_Editor.InsertItem(7,"Robert King¦Sales Representative¦Kirkland¦(71) 555-5598",2,2) var_Editor.InsertItem(8,"Laura Callahan¦Inside Sales Coordinator¦Seattle¦(206) 555-1189",3,2) var_Editor.InsertItem(9,"Anne Dodsworth¦Sales Representative¦London¦(71) 555-4444",2,5) var_Editor.ExpandAll() var_Items = oG2antt.Items var_Items.AddItem(1) var_Items.AddItem(2) var_Items.AddItem(4) oG2antt.EndUpdate() |
2160 |
Does you control support multiple-columns for a drop down editor
OleObject oG2antt,var_Editor,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Chart.PaneWidth(true,0) oG2antt.HeaderAppearance = 4 var_Editor = oG2antt.Columns.Add("Multiple-Columns DropDownListType").Editor var_Editor.EditType = 3 var_Editor.DropDownAutoWidth = 0 var_Editor.AddItem(0,"Jollyville¦JV3¦3026N 09746W¦TX") var_Editor.AddItem(1,"Altamont¦TMO¦4021N 11017W¦UT") var_Editor.AddItem(2,"Williamston¦IIM¦4241N 08417W¦MI") var_Editor.AddItem(3,"Merrittstown¦IWN¦3958N 07952W¦PA") var_Editor.AddItem(4,"Houston¦HOU¦2945N 09521W¦TX") var_Editor.AddItem(5,"Gales Ferry¦GSF¦4125N 07205W¦CT") var_Items = oG2antt.Items var_Items.InsertItem(0,"",1) var_Items.InsertItem(0,"",2) var_Items.InsertItem(0,"",4) oG2antt.EndUpdate() |
2159 |
Is it possible to change the summary-bar's start or/and end margins
OleObject oG2antt,var_Chart,var_Column,var_Column1,var_Items any h1,hR1 oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.HeaderAppearance = 4 oG2antt.LinesAtRoot = 5 oG2antt.ColumnAutoResize = false var_Chart = oG2antt.Chart var_Chart.AllowCreateBar = false var_Chart.AllowLinkBars = false var_Chart.FirstVisibleDate = 2008-01-01 var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,256) oG2antt.Columns.Add("Members").Width = 96 var_Column = oG2antt.Columns.Add("Start") var_Column.Width = 112 var_Column.Def(18,1) var_Column.LevelKey = 1 var_Column1 = oG2antt.Columns.Add("End") var_Column1.Width = 112 var_Column1.Def(18,2) var_Column1.LevelKey = 1 var_Items = oG2antt.Items var_Items.AllowCellValueToItemBar = true hR1 = var_Items.AddItem("Team") var_Items.AddBar(hR1,"Summary",2008-01-02,2008-01-08,"") var_Items.AddBar(hR1,"",2008-01-13,2008-01-13,"R") var_Items.ItemBar(hR1,"R",19,100) var_Items.DefineSummaryBars(hR1,"",h1,"R") h1 = var_Items.InsertItem(hR1,,"Member 1") var_Items.AddBar(h1,"Task",2008-01-02,2008-01-07) var_Items.DefineSummaryBars(hR1,"",h1,"") h1 = var_Items.InsertItem(hR1,,"Member 2") var_Items.AddBar(h1,"Task",2008-01-04,2008-01-09) var_Items.DefineSummaryBars(hR1,"",h1,"") h1 = var_Items.InsertItem(hR1,,"Member 3") var_Items.AddBar(h1,"Task",2008-01-05,2008-01-10) var_Items.DefineSummaryBars(hR1,"",h1,"") var_Items.ExpandItem(hR1,true) oG2antt.EndUpdate() |
2158 |
I want to display two lines/curves in the histogram-area such as expected and actual work effor per month. How can I do that (leaf)
OleObject oG2antt,var_Bar,var_Bar1,var_Chart,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() var_Chart = oG2antt.Chart var_Chart.PaneWidth(false,128) var_Chart.FirstVisibleDate = 2020-10-05 var_Chart.HistogramVisible = true var_Chart.HistogramHeight = 96 var_Chart.HistogramView = 1808 /*exHistogramNoGrouping | exHistogramRecLeafItems | exHistogramLeafItems | exHistogramUnlockedItems*/ var_Bar = var_Chart.Bars.Item("Task") var_Bar.HistogramPattern = 2048 var_Bar.HistogramItems = -4 var_Bar.HistogramBorderSize = 1 var_Bar1 = var_Chart.Bars.Copy("Task","C") var_Bar1.HistogramPattern = 2048 var_Bar1.HistogramItems = -4 var_Bar1.HistogramColor = RGB(255,0,0) var_Bar1.HistogramBorderSize = 2 oG2antt.Columns.Add("Column") var_Items = oG2antt.Items h = var_Items.AddItem("Project A") var_Items.AddBar(var_Items.InsertItem(h,,"Item 1"),"Task",2020-10-07,2020-10-14) var_Items.AddBar(var_Items.InsertItem(h,,"Item 2"),"Task",2020-10-10,2020-10-17) var_Items.ExpandItem(h,true) h = var_Items.AddItem("Project B") var_Items.AddBar(var_Items.InsertItem(h,,"Item 1"),"C",2020-10-13,2020-10-20) var_Items.AddBar(var_Items.InsertItem(h,,"Item 2"),"C",2020-10-15,2020-10-23) var_Items.ExpandItem(h,true) oG2antt.EndUpdate() |
2157 |
I want to display two lines/curves in the histogram-area such as expected and actual work effor per month. How can I do that (flat)
/*begin event BarResize(long Item,any Key) - Occurs when a bar is moved or resized.*/ /* OleObject var_Items oG2antt = ole_1.Object var_Items = oG2antt.Items var_Items.ItemBar(Item,Key,21,var_Items.ItemBar(Item,Key,12)) var_Items.ItemBar(Item,"C",21,1) */ /*end event BarResize*/ OleObject oG2antt,var_Bar,var_Bar1,var_Chart,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.HeaderVisible = 1 oG2antt.HeaderAppearance = 4 var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = 2020-10-05 var_Chart.PaneWidth(false,128) var_Chart.LevelCount = 2 var_Chart.HistogramHeight = 96 var_Chart.HistogramVisible = true var_Bar = var_Chart.Bars.Add("Task%Progress") var_Bar.HistogramPattern = 2048 var_Bar.HistogramItems = -4 var_Bar.HistogramBorderSize = 1 var_Bar.HistogramBorderColor = var_Bar.Color var_Bar.Shortcut = "P" var_Bar.Def(14,true) var_Bar1 = var_Chart.Bars.Copy("Task","C") var_Bar1.HistogramPattern = 2048 var_Bar1.HistogramColor = RGB(255,0,0) var_Bar1.HistogramBorderSize = 2 oG2antt.Columns.Add("Tasks").FormatColumn = "`Task ` + (1 index ``)" var_Items = oG2antt.Items h = var_Items.AddItem() var_Items.AddBar(h,"P",2020-10-07,2020-10-14,"P") var_Items.ItemBar(h,"P",12,0.5) var_Items.AddBar(h,"C",2020-10-07,2020-10-14,"C") var_Items.ItemBar(h,"C",19,100) var_Items.GroupBars(h,"P",true,h,"C",true) var_Items.GroupBars(h,"P",false,h,"C",false) h = var_Items.AddItem() var_Items.AddBar(h,"P",2020-10-10,2020-10-17,"P") var_Items.ItemBar(h,"P",12,0.75) var_Items.AddBar(h,"C",2020-10-10,2020-10-17,"C") var_Items.ItemBar(h,"C",19,100) var_Items.GroupBars(h,"P",true,h,"C",true) var_Items.GroupBars(h,"P",false,h,"C",false) h = var_Items.AddItem() var_Items.AddBar(h,"P",2020-10-13,2020-10-20,"P") var_Items.ItemBar(h,"P",12,0.25) var_Items.AddBar(h,"C",2020-10-13,2020-10-20,"C") var_Items.ItemBar(h,"C",19,100) var_Items.GroupBars(h,"P",true,h,"C",true) var_Items.GroupBars(h,"P",false,h,"C",false) oG2antt.EndUpdate() |
2156 |
Is it possible to show the filterbar on top of the rows
OleObject oG2antt,var_Column,var_Column1,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.FilterBarPromptVisible = 8192 oG2antt.HeaderHeight = 24 oG2antt.FilterBarHeight = oG2antt.HeaderHeight oG2antt.HeaderAppearance = 1 oG2antt.DrawGridLines = -1 oG2antt.GridLineStyle = 512 var_Column = oG2antt.Columns.Add("Column") var_Column.DisplayFilterButton = true var_Column.FilterType = 3 var_Column.Filter = "B*" var_Column1 = oG2antt.Columns.Add("Index") var_Column1.FormatColumn = "1 index ``" var_Column1.Position = 0 var_Column1.Width = 48 var_Column1.AllowSizing = false var_Column1.SortType = 1 var_Column1.Def(0,true) var_Items = oG2antt.Items var_Items.AddItem("A.1") var_Items.AddItem("A.2") var_Items.AddItem("B.1") var_Items.AddItem("B.2") var_Items.AddItem("B.3") var_Items.AddItem("C") oG2antt.ApplyFilter() oG2antt.EndUpdate() |
2155 |
The deadline symbol is now a white arrow and it is difficult to see. I want to create a green or black arrow for showing deadline
OleObject oG2antt,var_Bar,var_Chart,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = 2001-01-01 var_Chart.PaneWidth(false,96) var_Bar = var_Chart.Bars.Item("Deadline") var_Bar.StartColor = RGB(0,128,0) var_Bar.StartShape = 12 var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem("Task"),"Deadline",2001-01-02,2001-01-02) oG2antt.EndUpdate() |
2154 |
DragDrop (with visual effect)
/*begin event OLEDragDrop(oleobject Data,long Effect,integer Button,integer Shift,long X,long Y) - Occurs when a source component is dropped onto a target component when the source component determines that a drop can occur.*/ /* SelectItem(InsertItem(i,, Data.GetData(1))) = True OleObject var_Items any i oG2antt = ole_1.Object i = oG2antt.ItemFromPoint(-1,-1,c,hit) var_Items = oG2antt.Items var_Items.ExpandItem(i,true) */ /*end event OLEDragDrop*/ /*begin event OLEStartDrag(oleobject Data,long AllowedEffects) - Occurs when the OLEDrag method is called.*/ /* Data.SetData(Me.Items.CellCaption(FocusItem, 0), 1) oG2antt = ole_1.Object AllowedEffects = 1 */ /*end event OLEStartDrag*/ OleObject oG2antt,var_Items any h oG2antt = ole_1.Object oG2antt.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABPUIQAAYAQGKIcBiAKBQAGaAoDgYN4MAANAwjJBMKgBBCLIxhEYobgmGIaRjEEQDCKYcxHCaIBiGcaIfDEBIeSBHcgRbAcOQHGSZZBhGRJGjuKIbSrLICzBDUcRnGwAKQoaaaEomHwyAZOYwDAIoWhpKKCKjqWJKNb+XgAAJTES0RRVRTNAZ1YghGAQgIA==") oG2antt.Background(96,16777216 /*0x1000000*/) oG2antt.Background(97,RGB(1,0,0)) oG2antt.Background(33,RGB(0,0,0)) oG2antt.Background(34,RGB(255,255,255)) oG2antt.OLEDropMode = 1 oG2antt.AutoDrag = 196608 oG2antt.LinesAtRoot = -1 oG2antt.Indent = 16 oG2antt.SelBackMode = 1 oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") var_Items.ExpandItem(h,true) MessageBox("Information",string( "You can:" )) MessageBox("Information",string( "A) left-click to drag and drop items between controls (open a new exhelper and run the same sample)" )) MessageBox("Information",string( "B) right-click to re-arrange the item position inside the same control" )) MessageBox("Information",string( "This sample shows how you can insert the data being dropped as a child of the item being hovered." )) |
2153 |
DragDrop (with no visual effect, hide item while drag and drop)
/*begin event OLEDragDrop(oleobject Data,long Effect,integer Button,integer Shift,long X,long Y) - Occurs when a source component is dropped onto a target component when the source component determines that a drop can occur.*/ /* SelectItem(InsertItem(i,, Data.GetData(1))) = True OleObject var_Items any i oG2antt = ole_1.Object i = oG2antt.ItemFromPoint(-1,-1,c,hit) var_Items = oG2antt.Items var_Items.ExpandItem(i,true) */ /*end event OLEDragDrop*/ /*begin event OLEStartDrag(oleobject Data,long AllowedEffects) - Occurs when the OLEDrag method is called.*/ /* Data.SetData(Me.Items.CellCaption(FocusItem, 0), 1) oG2antt = ole_1.Object AllowedEffects = 1 */ /*end event OLEStartDrag*/ OleObject oG2antt,var_Items any h oG2antt = ole_1.Object oG2antt.Background(33,RGB(0,0,0)) oG2antt.Background(34,RGB(255,255,255)) oG2antt.OLEDropMode = 1 oG2antt.AutoDrag = 196608 oG2antt.LinesAtRoot = -1 oG2antt.Indent = 16 oG2antt.SelBackMode = 1 oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") var_Items.ExpandItem(h,true) MessageBox("Information",string( "You can:" )) MessageBox("Information",string( "A) left-click to drag and drop items between controls (open a new exhelper and run the same sample)" )) MessageBox("Information",string( "B) right-click to re-arrange the item position inside the same control" )) MessageBox("Information",string( "This sample shows how you can insert the data being dropped as a child of the item being hovered." )) |
2152 |
DragDrop
/*begin event OLEDragDrop(oleobject Data,long Effect,integer Button,integer Shift,long X,long Y) - Occurs when a source component is dropped onto a target component when the source component determines that a drop can occur.*/ /* SelectItem(InsertItem(i,, Data.GetData(1))) = True OleObject var_Items any i oG2antt = ole_1.Object i = oG2antt.ItemFromPoint(-1,-1,c,hit) var_Items = oG2antt.Items var_Items.ExpandItem(i,true) */ /*end event OLEDragDrop*/ /*begin event OLEStartDrag(oleobject Data,long AllowedEffects) - Occurs when the OLEDrag method is called.*/ /* Data.SetData(Me.Items.CellCaption(FocusItem, 0), 1) oG2antt = ole_1.Object AllowedEffects = 1 */ /*end event OLEStartDrag*/ OleObject oG2antt,var_Items any h oG2antt = ole_1.Object oG2antt.OLEDropMode = 1 oG2antt.AutoDrag = 196608 oG2antt.LinesAtRoot = -1 oG2antt.Indent = 16 oG2antt.SelBackMode = 1 oG2antt.Columns.Add("Default") var_Items = oG2antt.Items h = var_Items.AddItem("Root") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") var_Items.ExpandItem(h,true) MessageBox("Information",string( "You can:" )) MessageBox("Information",string( "A) left-click to drag and drop items between controls (open a new exhelper and run the same sample)" )) MessageBox("Information",string( "B) right-click to re-arrange the item position inside the same control" )) MessageBox("Information",string( "This sample shows how you can insert the data being dropped as a child of the item being hovered." )) |
2151 |
Is there anyway to stop the header changing colour when the mouse hovers/moves across the column header (non-clickable)
OleObject oG2antt,var_Column,var_Columns,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.HeaderAppearance = 4 var_Columns = oG2antt.Columns var_Columns.Add("Item") var_Column = var_Columns.Add("Pos") var_Column.Position = 0 var_Column.Width = 32 var_Column.AllowSizing = false var_Column.FormatColumn = "1 index ``" var_Column.AllowSort = false var_Column.AllowDragging = false var_Items = oG2antt.Items var_Items.AddItem("Item A") var_Items.AddItem("Item B") var_Items.AddItem("Item C") oG2antt.EndUpdate() |
2150 |
Is there anyway to stop the header changing colour when the mouse hovers/moves across the column header
OleObject oG2antt,var_Column,var_Columns,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.HeaderAppearance = 4 oG2antt.Background(32,-1) var_Columns = oG2antt.Columns var_Columns.Add("Item") var_Column = var_Columns.Add("Pos") var_Column.Position = 0 var_Column.Width = 32 var_Column.AllowSizing = false var_Column.FormatColumn = "1 index ``" var_Column.AllowSort = false var_Column.AllowDragging = false var_Items = oG2antt.Items var_Items.AddItem("Item A") var_Items.AddItem("Item B") var_Items.AddItem("Item C") oG2antt.EndUpdate() |
2149 |
How can I detect the last visible item
/*begin event SelectionChanged() - Fired after a new item has been selected.*/ /* OleObject var_Items oG2antt = ole_1.Object var_Items = oG2antt.Items MessageBox("Information",string( String(var_Items.NextVisibleItem(var_Items.FocusItem)) )) */ /*end event SelectionChanged*/ OleObject oG2antt,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 oG2antt.AutoDrag = 3 oG2antt.Columns.Add("Column") var_Items = oG2antt.Items var_Items.InsertItem(var_Items.AddItem("Item 1"),,"Child 1") var_Items.AddItem("Item 2") var_Items.AddItem("Item 3") var_Items.InsertItem(var_Items.AddItem("Item 4"),,"Child 4") var_Items.AddItem("Item 5") oG2antt.EndUpdate() |
2148 |
Is it possible to show the non-working part on the back (behind the item's background)
/*begin event CellStateChanged(long Item,long ColIndex) - Fired after cell's state has been changed.*/ /* oG2antt = ole_1.Object oG2antt.Refresh() */ /*end event CellStateChanged*/ OleObject oG2antt,var_Appearance,var_Bar,var_Chart,var_Column,var_ConditionalFormat,var_Items any h,hChild oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.LinesAtRoot = 5 oG2antt.SelBackMode = 1 oG2antt.DefaultItemHeight = 22 oG2antt.GridLineStyle = 48 oG2antt.DrawGridLines = -1 oG2antt.HeaderVisible = 1 oG2antt.HeaderAppearance = 4 var_Column = oG2antt.Columns.Add("Tasks") var_Column.Def(0,true) var_Column.PartialCheck = true var_Appearance = oG2antt.VisualAppearance var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABUkIQAAYAQGKIcBiAKBQAGYBIJDEMQ3DjAUBjMK4ZwTC4AIQjCK4JDKHYJRpHEZgLBMJAAGIZYhhUYRUiYMkiJBGGDIDiGGI2SJAcbTVIEcx9EyUJSgSTJOjCMokTTIU4TTLYASbJafJJhWSaAiyMouDIOMg1BDNIw/Hika6jOgKUisNJXRzWIBTbDlOQ3JqnbCjOQRSrQBoNDAMAiiaKlbwJPK9RoieQXfwUAJrXJcFqXFSLVxNBKAQEBA=") var_Appearance.Add(4,"gBFLBCJwBAEHhEJAAEhABTcIQAAYAQGKIcBiAKBQAGaAoDgYN4MAANAwjJBMKgBBCLIxhEYobgmGIaRiBMIxAKIZhzEiJYgGIZxYh8MQER5IEbyBDsBw5AaZZojGRJGigNIqSxLUhTRKUdQrG4AKQnGhpDgmJYnU5EcrSUKQcw/JaiKYpGZYXpqO5OTzUIyVHDdKgFGKNKwjKiKKp6FofDJcADUcKAYBKFoaLjgS5bXhSGpnV5bFoWdLTVwhBKAQEBA=") var_Appearance.Add(1,"CP:2 1 1 -1 -1") var_Appearance.Add(3,"CP:4 1 1 -1 -1") var_ConditionalFormat = oG2antt.ConditionalFormats.Add("%CS0 = 1") var_ConditionalFormat.BackColor = 50331648 /*0x3000000*/ var_ConditionalFormat.ChartBackColor = var_ConditionalFormat.BackColor var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = 2017-08-01 var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,128) var_Chart.Bars.Item("Task").Pattern = 1 var_Bar = var_Chart.Bars.Item("Summary") var_Bar.StartShape = 0 var_Bar.EndShape = 0 var_Bar.Shape = 4 var_Chart.SelBackColor = oG2antt.SelBackColor var_Chart.SelBarColor = RGB(128,128,128) var_Chart.DrawGridLines = -1 var_Chart.NonworkingDaysPattern = 1 var_Chart.GridLineStyle = 304 /*exGridLinesBehind | exGridLinesSolid*/ var_Items = oG2antt.Items h = var_Items.AddItem("Project") hChild = var_Items.InsertItem(h,,"Task 1") var_Items.AddBar(hChild,"Task",2017-08-02,2017-08-08) var_Items.SelectItem(hChild,true) hChild = var_Items.InsertItem(h,,"Task 2") var_Items.AddBar(hChild,"Task",2017-08-03,2017-08-10) hChild = var_Items.InsertItem(h,,"Task 3") var_Items.AddBar(hChild,"Task",2017-08-04,2017-08-12) var_Items.CellState(hChild,0,1) hChild = var_Items.InsertItem(h,,"Task 4") var_Items.AddBar(hChild,"Task",2017-08-05,2017-08-14) hChild = var_Items.InsertItem(h,,"Task 5") var_Items.AddBar(hChild,"Task",2017-08-06,2017-08-16) var_Items.AddBar(h,"Summary",2017-08-01,2017-08-01,"sum") var_Items.DefineSummaryBars(h,"sum",-3,"") var_Items.ExpandItem(h,true) h = var_Items.AddItem("ItemBackColor") var_Items.AddBar(h,"Progress",2017-08-04,2017-08-14) var_Items.ItemBackColor(h,25198847 /*0x18080ff*/) oG2antt.Chart.ItemBackColor(h,25198847 /*0x18080ff*/) oG2antt.EndUpdate() |
2147 |
How can I hide a bar within the control's overview (sample 1)
OleObject oG2antt,var_Chart,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Default") oG2antt.Background(18,RGB(190,190,190)) oG2antt.BackColorLevelHeader = oG2antt.BackColor var_Chart = oG2antt.Chart var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,64) var_Chart.OverviewHeight = 48 var_Chart.OverviewVisible = 73730 /*exOverviewSplitter | exOverviewShowMargins | exOverviewShowAllVisible*/ var_Chart.FirstVisibleDate = 2020-01-01 var_Chart.Bars.Copy("Task","TaskO").Color = RGB(255,0,0) var_Items = oG2antt.Items var_Items.AddItem("") h = var_Items.AddItem("") var_Items.AddBar(h,"Task",2020-01-02,2020-01-12,"K1") var_Items.AddBar(h,"Task",2020-12-02,2020-12-12,"K2") h = var_Items.AddItem("") var_Items.AddBar(h,"TaskO",2020-01-02,2020-01-12,"K1") var_Items.ItemBar(h,"K1",41,-1) var_Items.AddBar(h,"TaskO",2020-12-02,2020-12-12,"K2") var_Items.ItemBar(h,"K2",41,-1) h = var_Items.AddItem("") var_Items.AddBar(h,"Task",2020-01-02,2020-01-12,"K1") var_Items.AddBar(h,"Task",2020-12-02,2020-12-12,"K2") oG2antt.EndUpdate() |
2146 |
How can I hide all bars within the control's overview (sample 2)
OleObject oG2antt,var_Bar,var_Chart,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Default") oG2antt.Background(18,RGB(190,190,190)) oG2antt.BackColorLevelHeader = oG2antt.BackColor var_Chart = oG2antt.Chart var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,64) var_Chart.OverviewHeight = 48 var_Chart.OverviewVisible = 8705 /*exOverviewShowMargins | exOverviewHideBars | exOverviewShowOnlyVisible*/ var_Chart.FirstVisibleDate = 2020-01-01 var_Bar = var_Chart.Bars.Copy("Task","TaskO") var_Bar.OverviewColor = -1 var_Bar.Color = RGB(255,0,0) var_Items = oG2antt.Items var_Items.AddItem("") h = var_Items.AddItem("") var_Items.AddBar(h,"Task",2020-01-02,2020-01-12,"K1") var_Items.AddBar(h,"Task",2020-12-02,2020-12-12,"K2") h = var_Items.AddItem("") var_Items.AddBar(h,"TaskO",2020-01-02,2020-01-12,"K1") var_Items.AddBar(h,"TaskO",2020-12-02,2020-12-12,"K2") h = var_Items.AddItem("") var_Items.AddBar(h,"Task",2020-01-02,2020-01-12,"K1") var_Items.AddBar(h,"Task",2020-12-02,2020-12-12,"K2") oG2antt.EndUpdate() |
2145 |
How can I hide all bars or specified type within the control's overview (sample 3)
OleObject oG2antt,var_Bar,var_Chart,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Default") oG2antt.Background(18,RGB(190,190,190)) oG2antt.BackColorLevelHeader = oG2antt.BackColor var_Chart = oG2antt.Chart var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,64) var_Chart.OverviewHeight = 48 var_Chart.OverviewVisible = 73730 /*exOverviewSplitter | exOverviewShowMargins | exOverviewShowAllVisible*/ var_Chart.FirstVisibleDate = 2020-01-01 var_Bar = var_Chart.Bars.Copy("Task","TaskO") var_Bar.OverviewColor = -1 var_Bar.Color = RGB(255,0,0) var_Items = oG2antt.Items var_Items.AddItem("") h = var_Items.AddItem("") var_Items.AddBar(h,"Task",2020-01-02,2020-01-12,"K1") var_Items.AddBar(h,"Task",2020-12-02,2020-12-12,"K2") h = var_Items.AddItem("") var_Items.AddBar(h,"TaskO",2020-01-02,2020-01-12,"K1") var_Items.AddBar(h,"TaskO",2020-12-02,2020-12-12,"K2") h = var_Items.AddItem("") var_Items.AddBar(h,"Task",2020-01-02,2020-01-12,"K1") var_Items.AddBar(h,"Task",2020-12-02,2020-12-12,"K2") oG2antt.EndUpdate() |
2144 |
Is it possible to exclude the parent/child items when do the filtering, so to include only items that match the filter without any indentation
/*begin event AddItem(long Item) - Occurs after a new Item has been inserted to Items collection.*/ /* oG2antt = ole_1.Object oG2antt.Items.AddBar(Item,"Task",2001-01-02,2001-01-09) */ /*end event AddItem*/ /*begin event FilterChange() - Occurs when the filter was changed.*/ /* oG2antt = ole_1.Object oG2antt.Indent = oG2antt.FormatABC("value > 0 ? 18 : 0",.Items.MatchItemCount) */ /*end event FilterChange*/ OleObject oG2antt,var_Chart,var_Column,var_Column1,var_Columns,var_Items any h,h2 oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 oG2antt.Indent = 18 oG2antt.FilterInclude = 4 oG2antt.DrawGridLines = 2 oG2antt.HeaderAppearance = 1 var_Chart = oG2antt.Chart var_Chart.LevelCount = 2 var_Chart.FirstVisibleDate = 2001-01-01 var_Chart.PaneWidth(false,164) var_Columns = oG2antt.Columns var_Column = var_Columns.Add("Column") var_Column.DisplayFilterButton = true var_Column.FilterType = 240 var_Column.FilterList = 256 var_Column.Filter = "C1" var_Column1 = var_Columns.Add("Pos") var_Column1.FormatColumn = "1 rindex ``" var_Column1.Position = 0 var_Column1.AllowSizing = false var_Column1.AllowDragging = false var_Items = oG2antt.Items h = var_Items.AddItem("R1") h2 = var_Items.InsertItem(h,,"S") var_Items.InsertItem(h2,,"C1") var_Items.InsertItem(h2,,"C2") var_Items.InsertItem(h,,"C1") var_Items.InsertItem(h,,"C2") var_Items.ExpandItem(h,true) h = var_Items.AddItem("R2") var_Items.InsertItem(h,,"C1") var_Items.InsertItem(h,,"C2") oG2antt.ApplyFilter() oG2antt.EndUpdate() |
2143 |
I am using the Chart.AllowResizeChart property. How can I customize the labels into the chart's levels
OleObject oG2antt,var_Chart,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.AllowResizeChart = 262 /*exAllowChangeUnitScale | exAllowResizeChartMiddle | exAllowResizeChartHeader*/ var_Chart.Label(0,"year") var_Chart.Label(1,"") var_Chart.Label(2,"") var_Chart.Label(16,"month") var_Chart.Label(17,"") var_Chart.Label(256,"week") var_Chart.Label(4096,"day") var_Chart.Label(65536,"hour") var_Chart.Label(1048576,"") var_Chart.Label(16777216,"") var_Chart.ShowNonworkingDates = false var_Chart.LevelCount = 2 var_Chart.FirstVisibleDate = 2001-01-01 var_Chart.PaneWidth(false,48) var_Chart.UnitWidth = 32 var_Chart.UnitScale = 4096 var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem("Task A"),"Task",2001-01-02,2001-01-06,"K1") var_Items.AddBar(var_Items.AddItem("Task B"),"Task",2001-01-06,2001-01-10,"K1") var_Items.AddBar(var_Items.AddItem("Task C"),"Task",2001-01-10,2001-01-14,"K1") var_Items.AddBar(var_Items.AddItem(""),"",2001-01-08,2001-01-08,"Info","Click the <b>middle</b> mouse button and start dragging") oG2antt.EndUpdate() |
2142 |
Is it possible to display the header using multiple lines, while chart display multiple levels (sample 2)
/*begin event AddColumn(oleobject Column) - Fired after a new column has been added.*/ /* Column.Def(52) = 4 Column.Def(53) = 4 oG2antt = ole_1.Object */ /*end event AddColumn*/ OleObject oG2antt,var_Chart,var_Columns oG2antt = ole_1.Object oG2antt.BeginUpdate() var_Chart = oG2antt.Chart var_Chart.LevelCount = 2 var_Chart.PaneWidth(true,256) oG2antt.HeaderVisible = 1 oG2antt.HeaderAppearance = 1 var_Columns = oG2antt.Columns var_Columns.Add("Column") var_Columns.Add("C1").HTMLCaption = "<b>C<off 4>1</b><br>left" var_Columns.Add("C2").HTMLCaption = "<c><b>C<off 4>2</b><br><c>center" var_Columns.Add("C3").HTMLCaption = "<r><b>C<off 4>3</b><br><r>right" oG2antt.EndUpdate() |
2141 |
Is there any way to control the z-order of a TimeZone
OleObject oG2antt,var_Chart oG2antt = ole_1.Object var_Chart = oG2antt.Chart var_Chart.PaneWidth(false,0) var_Chart.UnitWidth = 15 var_Chart.LevelCount = 2 var_Chart.FirstVisibleDate = 2009-12-28 var_Chart.MarkTimeZone("Top",2010-01-01,2010-01-05,16711680,"1;;<fgcolor=FFFFFF>Top;1") var_Chart.MarkTimeZone("Partial",2010-01-08,2010-01-12,16711680,"50;;<fgcolor=FFFFFF>Partial;1") var_Chart.MarkTimeZone("Default",2010-01-15,2010-01-19,16711680,";;<fgcolor=FFFFFF>Default;1") |
2140 |
Is it possible to display the header using multiple lines, while chart display multiple levels (sample 1)
|
2139 |
Difference between HistogramValueFromPoint and HistogramValue (sample 2)
/*begin event MouseMove(integer Button,integer Shift,long X,long Y) - Occurs when the user moves the mouse.*/ /* OleObject var_Chart any format,v1,v2,vMax,vMin oG2antt = ole_1.Object var_Chart = oG2antt.Chart v1 = var_Chart.HistogramValueFromPoint(-1,-1) v2 = var_Chart.HistogramValue(var_Chart.DateFromPoint(-1,-1)) vMin = var_Chart.HistogramValue("min") vMax = var_Chart.HistogramValue("max") format = oG2antt.FormatABC("`<b>ValueFromPoint</b>: ` + A + `<br>ValueFromDate: ` + B",v1,v2) format = oG2antt.FormatABC("A + `<br>Min: ` + B + `<br>Max: ` + C",format,vMin,vMax) oG2antt.ShowToolTip(String(format),,,"16","16") */ /*end event MouseMove*/ OleObject oG2antt,var_Bar,var_Chart,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Tasks") var_Chart = oG2antt.Chart var_Chart.FirstWeekDay = 1 var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,40) var_Chart.FirstVisibleDate = 2005-06-09 var_Chart.HistogramVisible = true var_Chart.HistogramView = 8304 /*exHistogramGroupCumulative | exHistogramAllItems*/ var_Chart.HistogramHeight = 128 var_Bar = var_Chart.Bars.Item("Task") var_Bar.HistogramPattern = var_Bar.Pattern var_Bar.HistogramType = 256 var_Bar.HistogramItems = -6 var_Bar.HistogramRulerLinesColor = RGB(0,0,1) var_Bar.HistogramBorderSize = 1 var_Bar.HistogramBorderColor = RGB(0,0,1) var_Bar.HistogramCumulativeOriginalColorBars = 0 var_Bar.HistogramCumulativeShowLegend = -1 var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem("Task"),"Task",2005-06-10,2005-06-14,"") var_Items.AddBar(var_Items.AddItem("Task"),"Task",2005-06-11,2005-06-15,"") var_Items.AddBar(var_Items.AddItem("Task"),"Task",2005-06-12,2005-06-16,"") oG2antt.EndUpdate() |
2138 |
Difference between HistogramValueFromPoint and HistogramValue (sample 1)
/*begin event MouseMove(integer Button,integer Shift,long X,long Y) - Occurs when the user moves the mouse.*/ /* OleObject var_Chart any format,v1,v2,vMax,vMin oG2antt = ole_1.Object var_Chart = oG2antt.Chart v1 = var_Chart.HistogramValueFromPoint(-1,-1) v2 = var_Chart.HistogramValue(var_Chart.DateFromPoint(-1,-1)) vMin = var_Chart.HistogramValue("min") vMax = var_Chart.HistogramValue("max") format = oG2antt.FormatABC("`<b>ValueFromPoint</b>: ` + A + `<br>ValueFromDate: ` + B",v1,v2) format = oG2antt.FormatABC("A + `<br>Min: ` + B + `<br>Max: ` + C",format,vMin,vMax) oG2antt.ShowToolTip(String(format),,,"16","16") */ /*end event MouseMove*/ OleObject oG2antt,var_Bar,var_Chart,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Tasks") var_Chart = oG2antt.Chart var_Chart.FirstWeekDay = 1 var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,40) var_Chart.FirstVisibleDate = 2005-06-09 var_Chart.HistogramVisible = true var_Chart.HistogramView = 112 var_Chart.HistogramHeight = 128 var_Bar = var_Chart.Bars.Item("Task") var_Bar.HistogramPattern = var_Bar.Pattern var_Bar.HistogramType = 0 var_Bar.HistogramItems = -6 var_Bar.HistogramRulerLinesColor = RGB(0,0,1) var_Bar.HistogramBorderSize = 1 var_Bar.HistogramBorderColor = RGB(0,0,1) var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem("Task"),"Task",2005-06-10,2005-06-14,"") var_Items.AddBar(var_Items.AddItem("Task"),"Task",2005-06-11,2005-06-15,"") var_Items.AddBar(var_Items.AddItem("Task"),"Task",2005-06-12,2005-06-16,"") oG2antt.EndUpdate() |
2137 |
I am using the Inside-Zoom feature, but the inside grid lines are more dashed the dotted
|
2136 |
I am using expressions for exBarEffort, but the histogram does not show correctly the data
OleObject oG2antt,var_Bar,var_Chart,var_InsideZoom,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.HeaderVisible = 1 oG2antt.HeaderAppearance = 4 var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = 2020-10-05 var_Chart.PaneWidth(false,128) var_Chart.LevelCount = 2 var_Chart.HistogramHeight = 96 var_Chart.HistogramVisible = true var_Chart.AllowInsideZoom = true var_Chart.DrawGridLines = -1 var_InsideZoom = var_Chart.InsideZooms.Add(2020-10-07) var_InsideZoom.Width = 196 var_Chart.DefaultInsideZoomFormat.GridLineStyle = 48 var_Bar = var_Chart.Bars.Item("Task") var_Bar.HistogramPattern = var_Bar.Pattern var_Bar.Def(3,"<%=%0%>") var_Bar.Def(4,18) var_Bar.Def(21,"(hour(value) > 5 and hour(value) < 18) ? 2 : 0") var_Chart.HistogramUnitScale = 65536 oG2antt.Columns.Add("Tasks").FormatColumn = "`Task ` + (1 index ``)" var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem(""),"Task",2020-10-07,2020-10-12) var_Items.AddBar(var_Items.AddItem(""),"Task",2020-10-08,2020-10-13) oG2antt.EndUpdate() |
2135 |
How can I specify the z-order of bars to be shown within the chart's histogram
OleObject oG2antt,var_Bar,var_Bar1,var_Chart,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.HeaderVisible = 1 oG2antt.HeaderAppearance = 4 var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = 2020-10-05 var_Chart.PaneWidth(false,128) var_Chart.LevelCount = 2 var_Chart.HistogramHeight = 96 var_Chart.HistogramVisible = true var_Bar = var_Chart.Bars.Add("A") var_Bar.Color = RGB(0,0,255) var_Bar.HistogramPattern = 1 var_Bar.HistogramItems = -6 var_Bar.HistogramCumulativeOriginalColorBars = 1 var_Bar.Def(3,"<%=%0%>") var_Bar.Def(4,18) var_Bar1 = var_Chart.Bars.Copy("A","B") var_Bar1.Color = RGB(0,255,0) var_Bar1.HistogramCumulativeOriginalColorBars = 1 var_Bar1.Def(3,"<%=%0%>") var_Bar1.Def(4,18) var_Chart.HistogramView = 8304 /*exHistogramGroupCumulative | exHistogramAllItems*/ var_Chart.HistogramZOrder = "A,B" oG2antt.Columns.Add("Tasks").FormatColumn = "`Task ` + (1 index ``)" var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem(""),"A",2020-10-07,2020-10-12) var_Items.AddBar(var_Items.AddItem(""),"A",2020-10-08,2020-10-13) var_Items.AddBar(var_Items.AddItem(""),"B",2020-10-09,2020-10-14) var_Items.AddBar(var_Items.AddItem(""),"B",2020-10-10,2020-10-15) oG2antt.EndUpdate() |
2134 |
How can I show cumulative histogram for two or more different types of bars
OleObject oG2antt,var_Bar,var_Bar1,var_Chart,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.HeaderVisible = 1 oG2antt.HeaderAppearance = 4 var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = 2020-10-05 var_Chart.PaneWidth(false,128) var_Chart.LevelCount = 2 var_Chart.HistogramHeight = 96 var_Chart.HistogramVisible = true var_Bar = var_Chart.Bars.Add("A") var_Bar.Color = RGB(0,0,255) var_Bar.HistogramPattern = 1 var_Bar.HistogramItems = -6 var_Bar.HistogramCumulativeOriginalColorBars = 1 var_Bar.Def(3,"<%=%0%>") var_Bar.Def(4,18) var_Bar1 = var_Chart.Bars.Copy("A","B") var_Bar1.Color = RGB(0,255,0) var_Bar1.HistogramCumulativeOriginalColorBars = 1 var_Bar1.Def(3,"<%=%0%>") var_Bar1.Def(4,18) var_Chart.HistogramView = 8304 /*exHistogramGroupCumulative | exHistogramAllItems*/ oG2antt.Columns.Add("Tasks").FormatColumn = "`Task ` + (1 index ``)" var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem(""),"A",2020-10-07,2020-10-12) var_Items.AddBar(var_Items.AddItem(""),"A",2020-10-08,2020-10-13) var_Items.AddBar(var_Items.AddItem(""),"B",2020-10-09,2020-10-14) var_Items.AddBar(var_Items.AddItem(""),"B",2020-10-10,2020-10-15) oG2antt.EndUpdate() |
2133 |
I would like to display a solid line between "root" items, and dotted lines (default) between child items. How can I do that
OleObject oG2antt,var_Column,var_Column1,var_ConditionalFormat,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 oG2antt.DrawGridLines = 1 oG2antt.GridLineStyle = 512 oG2antt.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABMsIQAAYAQGKIcBiAKBQAGaAoDgYN4MAANAwjJBMKgBBCLIxhEYobgmGIXRpFMbxAKQahLEiTIgGUYJHgmK4tQLHb7zGAABRDDSOIDnGQJXhaI4JQSMMQDGLAZxVFiPRhAWLpBh+PQATrOdLUfSjVwhBKAQEBA==") var_Column = oG2antt.Columns.Add("Default") var_Column.Def(0,true) var_Column.PartialCheck = true var_Column1 = oG2antt.Columns.Add("Position") var_Column1.FormatColumn = "((1 rindex ``) contains `.`) = 0" var_Column1.Visible = false var_ConditionalFormat = oG2antt.ConditionalFormats.Add("%C1") var_ConditionalFormat.BackColor = 31514848 /*0x1e0e0e0*/ var_Items = oG2antt.Items h = var_Items.AddItem("Root 1") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") var_Items.InsertItem(h,,"Child 3") var_Items.ExpandItem(h,true) h = var_Items.AddItem("Root 2") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") h = var_Items.AddItem("Root 3") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") oG2antt.EndUpdate() |
2132 |
I can not center or align the cell's caption and icon, when it displays the hierarchy
OleObject oG2antt,var_Column,var_Items any h,hChild oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") var_Column = oG2antt.Columns.Add("Tasks") var_Column.Def(17,1) oG2antt.HeaderVisible = 1 var_Items = oG2antt.Items h = var_Items.AddItem("Project") hChild = var_Items.InsertItem(h,,"<img>1</img> Task (left)") hChild = var_Items.InsertItem(h,,"<c><img>2</img> Task (center)") hChild = var_Items.InsertItem(h,,"<r>Task (right) <img>3</img>") var_Items.ExpandItem(h,true) oG2antt.EndUpdate() |
2131 |
How do I mask for float/integer number
OleObject oG2antt,var_Editor,var_Editor1,var_Editor2,var_Editor3,var_Editor4,var_Editor5,var_Editor6,var_Editor7,var_Editor8,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = true oG2antt.Columns.Add("Type").Width = 32 oG2antt.Columns.Add("Editor") var_Items = oG2antt.Items h = var_Items.AddItem("Integer") var_Items.CellValue(h,1,"12") var_Editor = var_Items.CellEditor(h,1) var_Editor.EditType = 1 var_Editor.Numeric = -1 h = var_Items.AddItem("Integer (mask, group)") var_Items.CellValue(h,1,"10002") var_Items.FormatCell(h,1,"value format `0||`") var_Editor1 = var_Items.CellEditor(h,1) var_Editor1.EditType = 8 var_Editor1.Mask = ";;;float,digits=0,invalid=empty,warning=invalid character" h = var_Items.AddItem("Integer (mask, no group)") var_Items.CellValue(h,1,"10002") var_Items.FormatCell(h,1,"value format `0|0|`") var_Editor2 = var_Items.CellEditor(h,1) var_Editor2.EditType = 8 var_Editor2.Mask = ";;;float,digits=0,grouping=,invalid=empty,warning=invalid character" h = var_Items.AddItem("Float") var_Items.CellValue(h,1,"+12.34E+2") var_Editor3 = var_Items.CellEditor(h,1) var_Editor3.EditType = 1 var_Editor3.Numeric = 1 h = var_Items.AddItem("Float (no signs)") var_Items.CellValue(h,1,"12.34E-2") var_Editor4 = var_Items.CellEditor(h,1) var_Editor4.EditType = 1 var_Editor4.Numeric = 769 /*exDisableSigns | exFloat*/ h = var_Items.AddItem("Float-Integer") var_Items.CellValue(h,1,"+12.34") var_Editor5 = var_Items.CellEditor(h,1) var_Editor5.EditType = 1 var_Editor5.Numeric = 2 h = var_Items.AddItem("Float-Integer (no signs)") var_Items.CellValue(h,1,"12.34") var_Editor6 = var_Items.CellEditor(h,1) var_Editor6.EditType = 1 var_Editor6.Numeric = 770 /*exDisableSigns | exFloatInteger*/ h = var_Items.AddItem("Float (mask,group)") var_Items.CellValue(h,1,"10002.34") var_Items.FormatCell(h,1,"value format `2`") var_Editor7 = var_Items.CellEditor(h,1) var_Editor7.EditType = 8 var_Editor7.Mask = ";;;float,invalid=empty,warning=invalid character" h = var_Items.AddItem("Float (mask, no group)") var_Items.CellValue(h,1,"10002.34") var_Items.FormatCell(h,1,"value format `2|0|`") var_Editor8 = var_Items.CellEditor(h,1) var_Editor8.EditType = 8 var_Editor8.Mask = ";;;float,grouping=,invalid=empty,warning=invalid character" oG2antt.EndUpdate() |
2130 |
Is it possible to offset (horizontally) the bar's caption
OleObject oG2antt,var_Bar,var_Chart,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("HOffset") oG2antt.HeaderAppearance = 1 oG2antt.ScrollBySingleLine = true oG2antt.DrawGridLines = -2 var_Chart = oG2antt.Chart var_Chart.DrawGridLines = -2 var_Chart.FirstVisibleDate = 2000-12-16 var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,128) var_Bar = var_Chart.Bars.Item("Task") var_Bar.Pattern = 32 var_Bar.Color = RGB(164,164,164) var_Bar.StartColor = RGB(240,240,240) var_Bar.EndColor = var_Bar.StartColor var_Bar.Height = 15 var_Bar.Def(3,"label") var_Items = oG2antt.Items h = var_Items.AddItem("right") var_Items.AddBar(h,"Task",2000-12-22,2000-12-27) var_Items.ItemBar(h,"",4,2) h = var_Items.AddItem("right - 4") var_Items.AddBar(h,"Task",2000-12-22,2000-12-27) var_Items.ItemBar(h,"",4,2) var_Items.ItemBar(h,"",58,-4) h = var_Items.AddItem("left") var_Items.AddBar(h,"Task",2000-12-22,2000-12-27) var_Items.ItemBar(h,"",4,0) h = var_Items.AddItem("left + 4") var_Items.AddBar(h,"Task",2000-12-22,2000-12-27) var_Items.ItemBar(h,"",4,0) var_Items.ItemBar(h,"",58,4) oG2antt.EndUpdate() |
2129 |
Is it possible to always center the bar's caption (even if the item-bar is partially visible)
OleObject oG2antt,var_Bar,var_Chart,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Align") oG2antt.HeaderAppearance = 1 oG2antt.ScrollBySingleLine = true oG2antt.DrawGridLines = -2 var_Chart = oG2antt.Chart var_Chart.DrawGridLines = -2 var_Chart.FirstVisibleDate = 2000-12-23 var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,128) var_Bar = var_Chart.Bars.Item("Task") var_Bar.Pattern = 32 var_Bar.Color = RGB(164,164,164) var_Bar.StartColor = RGB(240,240,240) var_Bar.EndColor = var_Bar.StartColor var_Bar.Height = 15 var_Items = oG2antt.Items h = var_Items.AddItem("default") var_Items.AddBar(h,"Task",2000-12-22,2000-12-27,"","label") var_Items.ItemBar(h,"",4,1) h = var_Items.AddItem("default + 32") var_Items.AddBar(h,"Task",2000-12-22,2000-12-27,"","label") var_Items.ItemBar(h,"",4,33) oG2antt.EndUpdate() |
2128 |
How do I set an extra data for each item
/*begin event MouseMove(integer Button,integer Shift,long X,long Y) - Occurs when the user moves the mouse.*/ /* any i oG2antt = ole_1.Object i = oG2antt.ItemFromPoint(-1,-1,c,hit) MessageBox("Information",string( String(i) )) MessageBox("Information",string( String(oG2antt.Items.ItemData(i)) )) */ /*end event MouseMove*/ OleObject oG2antt,var_Items,var_Items1 oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.ColumnAutoResize = true oG2antt.Columns.Add("Default") var_Items = oG2antt.Items var_Items.ItemData(var_Items.AddItem("method 1"),"your extra data of method 1") var_Items.InsertItem(0,"your extra data of method 2","method 2") var_Items1 = oG2antt.Items var_Items1.DefaultItem = var_Items1.AddItem("method 3") var_Items1.ItemData(0,"your extra data of method 3") oG2antt.EndUpdate() |
2127 |
Is it possible to show the position of rows the into the chart section
/*begin event BeforeExpandItem(long Item,any Cancel) - Fired before an item is about to be expanded (collapsed).*/ /* oG2antt = ole_1.Object oG2antt.Refresh() */ /*end event BeforeExpandItem*/ OleObject oG2antt,var_Bar,var_Chart,var_Column,var_Items any h,h1 oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Indent = 16 oG2antt.LinesAtRoot = -1 oG2antt.HasLines = 1 oG2antt.DrawGridLines = 1 oG2antt.ScrollBySingleLine = true oG2antt.FullRowSelect = 0 oG2antt.Columns.Add("Tasks") var_Column = oG2antt.Columns.Add("Pos") var_Column.Visible = false var_Column.FormatColumn = "`<r><bgcolor 000000><fgcolor FFFFFF> ` + 1 apos `` + ` </fgcolor></bgcolor>`" var_Column.Def(17,1) var_Chart = oG2antt.Chart var_Chart.ColumnsFormatLevel = ",|,1:64" var_Chart.FirstVisibleDate = 2006-09-20 var_Chart.ShowCollapsedBars = true var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,128) var_Chart.DrawGridLines = 1 var_Bar = var_Chart.Bars.Item("Task") var_Bar.OverlaidType = 3 var_Bar.Color = RGB(0,0,0) var_Bar.StartColor = RGB(196,196,196) var_Bar.EndColor = RGB(196,196,196) var_Bar.Pattern = 32 var_Items = oG2antt.Items h = var_Items.AddItem("Project 1") h1 = var_Items.InsertItem(h,,"Resources") var_Items.AddBar(h1,"Task",2006-09-21,2006-09-25,"A") var_Items.AddBar(h1,"Task",2006-09-24,2006-09-28,"B") var_Items.AddBar(h1,"Task",2006-09-27,2006-09-29,"C") h = var_Items.AddItem("Project 2") h1 = var_Items.InsertItem(h,,"Resources") var_Items.AddBar(h1,"Task",2006-09-21,2006-09-25,"A") var_Items.AddBar(h1,"Task",2006-09-24,2006-09-28,"B") var_Items.AddBar(h1,"Task",2006-09-27,2006-09-29,"C") var_Items.ExpandItem(h,true) oG2antt.EndUpdate() |
2126 |
I do not like to specify the item padding for every column I add. The question is how can I do it automatically
OleObject oG2antt,var_Column,var_Columns,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.AttachTemplate("handle AddColumn(Column){Column{Def(48)=8;Def(49)=8;AllowDragging=False;AllowSizing = True}}") oG2antt.HeaderAppearance = 4 oG2antt.DrawGridLines = -1 oG2antt.GridLineStyle = 32 var_Columns = oG2antt.Columns var_Columns.Add("Item") var_Column = var_Columns.Add("Pos") var_Column.Position = 0 var_Column.Width = 32 var_Column.AllowSizing = false var_Column.FormatColumn = "1 index ``" var_Items = oG2antt.Items var_Items.AddItem("Item A") var_Items.AddItem("Item B") var_Items.AddItem("Item C") oG2antt.EndUpdate() |
2125 |
Stack vs Cascade
OleObject oG2antt,var_Chart,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.ScrollBySingleLine = true oG2antt.HeaderAppearance = 1 oG2antt.Columns.Add("Type") oG2antt.BackColorAlternate = RGB(240,240,240) var_Chart = oG2antt.Chart var_Chart.LevelCount = 2 var_Chart.AllowCreateBar = 1 var_Chart.AllowLinkBars = false var_Chart.ResizeUnitScale = 65536 var_Chart.PaneWidth(false,128) var_Chart.FirstVisibleDate = 2001-01-01 var_Chart.Bars.Copy("Task","Stack").OverlaidType = 3 var_Chart.Bars.Copy("Task","AStack").OverlaidType = 515 /*exOverlaidBarsStackAutoArrange | exOverlaidBarsStack*/ var_Chart.Bars.Copy("Task","Cascade").OverlaidType = 4 var_Items = oG2antt.Items h = var_Items.AddItem("Stack") var_Items.AddBar(h,"Stack",2001-01-02,2001-01-04,"A1") var_Items.AddBar(h,"Stack",2001-01-03,2001-01-05,"A2") var_Items.AddBar(h,"Stack",2001-01-04,2001-01-07,"A3") var_Items.AddBar(h,"Stack",2001-01-02,2001-01-07,"A4") var_Items.AddBar(h,"Stack",2001-01-08,2001-01-12,"A5") var_Items.AddItem() h = var_Items.AddItem("Stack-AutoArrange") var_Items.AddBar(h,"AStack",2001-01-02,2001-01-04,"A1") var_Items.AddBar(h,"AStack",2001-01-03,2001-01-05,"A2") var_Items.AddBar(h,"AStack",2001-01-04,2001-01-07,"A3") var_Items.AddBar(h,"AStack",2001-01-02,2001-01-07,"A4") var_Items.AddBar(h,"AStack",2001-01-08,2001-01-12,"A5") var_Items.AddItem() h = var_Items.AddItem("Cascade") var_Items.AddBar(h,"Cascade",2001-01-02,2001-01-04,"A1") var_Items.AddBar(h,"Cascade",2001-01-03,2001-01-05,"A2") var_Items.AddBar(h,"Cascade",2001-01-04,2001-01-07,"A3") var_Items.AddBar(h,"Cascade",2001-01-02,2001-01-07,"A4") var_Items.AddBar(h,"Cascade",2001-01-08,2001-01-12,"A5") var_Items.AddItem() var_Items.ItemBar(0,"<*>",3,"<%=%9%>") oG2antt.EndUpdate() |
2124 |
How can I change the Exclude field in the drop down filter window
OleObject oG2antt,var_Column,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 oG2antt.HTMLPicture("exclude","gCJKBOI4NBQaBQAhQNJJIIhShQACERCAEAcRdrdcUQhQDOZCJJUBEjbbhJ7giIJOBILJziJvl4BeKibhDiIZOhFLB0KZvMx0O5hORlAB3owuNJuNZzMZhOBlFxvORnTbuHgaiIeKBMKhFf9fDIcEoPCAVEAlGI4HhBBYMCARCQVGg4IhVMCAWC2XY1Q7WJ8RBB0KROKYAYDBbzicjndD6fA/VsRHRJIhBkRbMYIGwGAQjA2fRYOEBoYjBFBx1ATCgCGQ8M7OTjSaJMDRDKIwYu5DrIMBgSAADKJTqhBhyRApAA3FAucZPPilokRJJFJxEVxCMCCgIA==") oG2antt.Description(25,"<img>exclude</img>") var_Column = oG2antt.Columns.Add("Items") var_Column.DisplayFilterButton = true var_Column.DisplayFilterPattern = false var_Column.FilterList = 9472 /*exShowExclude | exShowFocusItem | exShowCheckBox*/ var_Items = oG2antt.Items h = var_Items.AddItem("Root 1") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") var_Items.ExpandItem(h,true) h = var_Items.AddItem("Root 2") var_Items.InsertItem(h,,"Child 1") oG2antt.EndUpdate() |
2123 |
How can I change the Exclude field in the drop down filter window
OleObject oG2antt,var_Column,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 oG2antt.Description(25,"<bgcolor 0><fgcolor ffffff> Exclude </fgcolor></bgcolor>") var_Column = oG2antt.Columns.Add("Items") var_Column.DisplayFilterButton = true var_Column.DisplayFilterPattern = false var_Column.FilterList = 9472 /*exShowExclude | exShowFocusItem | exShowCheckBox*/ var_Items = oG2antt.Items h = var_Items.AddItem("Root 1") var_Items.InsertItem(h,,"Child 1") var_Items.InsertItem(h,,"Child 2") var_Items.ExpandItem(h,true) h = var_Items.AddItem("Root 2") var_Items.InsertItem(h,,"Child 1") oG2antt.EndUpdate() |
2122 |
The grid lines looks different then before. What should I do
OleObject oG2antt,var_Column,var_Items any h,hChild oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 var_Column = oG2antt.Columns.Add("Tasks") var_Column.Def(0,true) var_Column.PartialCheck = true oG2antt.DrawGridLines = -1 oG2antt.GridLineStyle = 512 oG2antt.Chart.DrawGridLines = oG2antt.DrawGridLines oG2antt.Chart.GridLineStyle = oG2antt.GridLineStyle oG2antt.HeaderVisible = 1 var_Items = oG2antt.Items h = var_Items.AddItem("Project") hChild = var_Items.InsertItem(h,,"Task 1") var_Items.SelectItem(hChild,true) hChild = var_Items.InsertItem(h,,"Task 2") var_Items.CellState(hChild,0,1) hChild = var_Items.InsertItem(h,,"Task 3") var_Items.CellState(hChild,0,1) var_Items.ExpandItem(h,true) oG2antt.EndUpdate() |
2121 |
How can I hide the task/bar's extra-caption
OleObject oG2antt,var_Bar,var_Chart,var_Column,var_Editor,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() var_Chart = oG2antt.Chart var_Chart.PaneWidth(false,96) var_Chart.FirstVisibleDate = 2011-01-01 var_Bar = var_Chart.Bars.Item("Task") var_Bar.Def(44,"<%=%C0%>") var_Bar.Def(4,18) var_Bar.Def(45,16) oG2antt.Columns.Add("Task") var_Column = oG2antt.Columns.Add("Show") var_Editor = var_Column.Editor var_Editor.EditType = 19 var_Editor.Option(17,1) var_Column.Def(18,57) var_Items = oG2antt.Items var_Items.AllowCellValueToItemBar = true var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",2011-01-03,2011-01-07) var_Items.ItemBar(var_Items.FirstVisibleItem,"",57,false) var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",2011-01-04,2011-01-08) oG2antt.EndUpdate() |
2120 |
How can I hide the task/bar's caption
OleObject oG2antt,var_Bar,var_Chart,var_Column,var_Editor,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() var_Chart = oG2antt.Chart var_Chart.PaneWidth(false,96) var_Chart.FirstVisibleDate = 2011-01-01 var_Bar = var_Chart.Bars.Item("Task") var_Bar.Def(3,"<%=%C0%>") var_Bar.Def(4,18) oG2antt.Columns.Add("Task") var_Column = oG2antt.Columns.Add("Show") var_Editor = var_Column.Editor var_Editor.EditType = 19 var_Editor.Option(17,1) var_Column.Def(18,56) var_Items = oG2antt.Items var_Items.AllowCellValueToItemBar = true var_Items.AddBar(var_Items.AddItem("Task 1"),"Task",2011-01-03,2011-01-07) var_Items.ItemBar(var_Items.FirstVisibleItem,"",56,false) var_Items.AddBar(var_Items.AddItem("Task 2"),"Task",2011-01-04,2011-01-08) oG2antt.EndUpdate() |
2119 |
Can I sort the column by check-state
OleObject oG2antt,var_Column,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() var_Column = oG2antt.Columns.Add("Check") var_Column.Def(0,true) var_Column.SortType = 32 var_Items = oG2antt.Items var_Items.AddItem() var_Items.CellState(var_Items.AddItem(),0,1) var_Items.CellState(var_Items.AddItem(),0,1) var_Items.AddItem() oG2antt.Columns.Item(0).SortOrder = 1 oG2antt.EndUpdate() |
2118 |
Can I sort the column by image
OleObject oG2antt,var_Column,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") var_Column = oG2antt.Columns.Add("Image") var_Column.SortType = 48 var_Items = oG2antt.Items var_Items.CellImage(var_Items.AddItem(),0,3) var_Items.AddItem() var_Items.CellImage(var_Items.AddItem(),0,1) var_Items.CellImage(var_Items.AddItem(),0,2) oG2antt.Columns.Item(0).SortOrder = 1 oG2antt.EndUpdate() |
2117 |
Can I sort the column by value(numeric)
OleObject oG2antt,var_Column,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() var_Column = oG2antt.Columns.Add("Value") var_Column.Def(17,1) var_Column.FormatColumn = "`<fgcolor=808080><off 4><font ;6> ` + (1 index ``) + ` </font></off></fgcolor>` + value" var_Column.SortType = 17 /*exSortByValue | SortNumeric*/ var_Items = oG2antt.Items var_Items.AddItem("1") var_Items.AddItem("10") var_Items.AddItem("2") var_Items.AddItem("20") oG2antt.Columns.Item(0).SortOrder = 1 oG2antt.EndUpdate() |
2116 |
Can I sort a column by cell's state (checked, unchecked) rather than caption
OleObject oG2antt,var_Column,var_Editor,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() var_Column = oG2antt.Columns.Add("Check") var_Editor = var_Column.Editor var_Editor.EditType = 19 var_Editor.Option(17,1) var_Column.SortType = 1 var_Items = oG2antt.Items var_Items.AddItem(true) var_Items.AddItem(false) var_Items.AddItem(false) var_Items.AddItem(true) oG2antt.Columns.Item(0).SortOrder = 1 oG2antt.EndUpdate() |
2115 |
How can I highlight(bold) the items that displays milestones (method 2)
OleObject oG2antt,var_Bar,var_Chart,var_Column,var_Column1,var_Columns,var_ConditionalFormat,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() var_Columns = oG2antt.Columns var_Columns.Add("Tasks") var_Columns.Add("Start").Def(18,1) var_Columns.Add("End").Def(18,543) var_Column = var_Columns.Add("Days") var_Column.Def(18,258) var_Column.FormatColumn = "value ? value : ``" var_Column1 = var_Columns.Add("Type") var_Column1.Def(18,0) var_Column1.Visible = false var_ConditionalFormat = oG2antt.ConditionalFormats.Add("%4 = `Milestone`") var_ConditionalFormat.Bold = true var_ConditionalFormat.Italic = true var_ConditionalFormat.ApplyTo = -1 var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = 2010-09-20 var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,256) var_Bar = var_Chart.Bars.Add("Task:Split") var_Bar.Shortcut = "Task" var_Bar.Def(20,true) var_Items = oG2antt.Items var_Items.AllowCellValueToItemBar = true var_Items.AddBar(var_Items.AddItem("M1"),"Milestone",2010-09-24,2010-09-24) var_Items.AddBar(var_Items.AddItem("T1"),"Task",2010-09-24,2010-09-28) var_Items.AddBar(var_Items.AddItem("T2"),"Task",2010-09-27,2010-09-28) var_Items.AddBar(var_Items.AddItem("M3"),"Milestone",2010-09-28,2010-09-28) oG2antt.EndUpdate() |
2114 |
How can I highlight(bold) the items that displays milestones (method 1)
OleObject oG2antt,var_Bar,var_Chart,var_Column,var_Columns,var_ConditionalFormat,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() var_Columns = oG2antt.Columns var_Columns.Add("Tasks") var_Columns.Add("Start").Def(18,1) var_Columns.Add("End").Def(18,543) var_Column = var_Columns.Add("Days") var_Column.Def(18,258) var_Column.FormatColumn = "value ? value : ``" var_ConditionalFormat = oG2antt.ConditionalFormats.Add("%3 = 0") var_ConditionalFormat.Bold = true var_ConditionalFormat.Italic = true var_ConditionalFormat.ApplyTo = -1 var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = 2010-09-20 var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,256) var_Bar = var_Chart.Bars.Add("Task:Split") var_Bar.Shortcut = "Task" var_Bar.Def(20,true) var_Items = oG2antt.Items var_Items.AllowCellValueToItemBar = true var_Items.AddBar(var_Items.AddItem("M1"),"Milestone",2010-09-24,2010-09-24) var_Items.AddBar(var_Items.AddItem("T1"),"Task",2010-09-24,2010-09-28) var_Items.AddBar(var_Items.AddItem("T2"),"Task",2010-09-27,2010-09-28) var_Items.AddBar(var_Items.AddItem("M3"),"Milestone",2010-09-28,2010-09-28) oG2antt.EndUpdate() |
2113 |
Bars with gradient shows no border or frame arround. What can be done (method 2)
OleObject oG2antt,var_Bar,var_Bar1,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") oG2antt.Chart.FirstVisibleDate = 2001-01-01 oG2antt.Chart.PaneWidth(false,48) oG2antt.DefaultItemHeight = 24 var_Bar = oG2antt.Chart.Bars.Add("E1") var_Bar.Color = RGB(0,0,0) var_Bar.StartColor = RGB(0,255,0) var_Bar.EndColor = RGB(255,255,0) var_Bar.Pattern = 96 /*exPatternGradientVBox | exPatternBox*/ var_Bar.Height = 20 var_Bar1 = oG2antt.Chart.Bars.Add("E2") var_Bar1.Color = RGB(0,0,0) var_Bar1.StartColor = RGB(0,255,0) var_Bar1.EndColor = RGB(255,255,0) var_Bar1.Pattern = 96 /*exPatternGradientVBox | exPatternBox*/ var_Bar1.Height = 20 var_Bar1.Def(53,"[frame=RGB(255,0,0),framethick]") var_Items = oG2antt.Items var_Items.AddItem() h = var_Items.AddItem("no border") var_Items.AddBar(h,"E1",2001-01-02,2001-01-08,"") h = var_Items.AddItem("w/h boder") var_Items.AddBar(h,"E2",2001-01-02,2001-01-08,"") var_Items.AddItem() oG2antt.EndUpdate() |
2112 |
Bars with gradient shows no border or frame arround. What can be done (method 1)
OleObject oG2antt,var_Bar,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") oG2antt.Chart.FirstVisibleDate = 2001-01-01 oG2antt.Chart.PaneWidth(false,48) oG2antt.DefaultItemHeight = 24 var_Bar = oG2antt.Chart.Bars.Add("E2") var_Bar.Color = RGB(0,0,0) var_Bar.StartColor = RGB(0,255,0) var_Bar.EndColor = RGB(255,255,0) var_Bar.Pattern = 96 /*exPatternGradientVBox | exPatternBox*/ var_Bar.Height = 20 var_Items = oG2antt.Items var_Items.AddItem() h = var_Items.AddItem("no border") var_Items.AddBar(h,"E2",2001-01-02,2001-01-08,"") h = var_Items.AddItem("w/h boder") var_Items.AddBar(h,"E2",2001-01-02,2001-01-08,"") var_Items.ItemBar(h,"",53,"[frame=RGB(255,0,0),framethick]") var_Items.AddItem() oG2antt.EndUpdate() |
2111 |
Is it possible to display auto-numbers (rows-numbers) for non-empty items only
OleObject oG2antt,var_Column,var_Columns,var_Items oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Chart.PaneWidth(false,128) var_Columns = oG2antt.Columns var_Columns.Add("Items") var_Column = var_Columns.Add("Pos") var_Column.FormatColumn = "len(%C0) ? 1 pos `` : ``" var_Column.Position = 0 var_Items = oG2antt.Items var_Items.AddItem("Item A") var_Items.AddItem("") var_Items.AddItem("Item B") var_Items.AddItem("") var_Items.AddItem("Item C") oG2antt.EndUpdate() |
2110 |
Is it possible to separate the group of items using horizontal-lines (root-items)
OleObject oG2antt,var_Chart,var_Column,var_Column1,var_Columns,var_ConditionalFormat,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABLEIQAAYAQGKIcBiAKBQAGaAoDgYN4MAANAwjJBMKgBBCLIxhEYobgmGIaRiAUbQSKEPxLEiPmqSHIEWwtDiBZgieTpNhAMg1CTNU4RAKoYRzBKeZ7kGZIVjKMofURRDpxBBMAkB") oG2antt.LinesAtRoot = -1 oG2antt.DefaultItemHeight = 24 oG2antt.SelBackMode = 1 var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = 2001-01-01 var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,196) var_Chart.SelBackColor = oG2antt.SelBackColor var_Columns = oG2antt.Columns var_Column = var_Columns.Add("Default") var_Column.Def(0,true) var_Column.PartialCheck = true var_Column1 = var_Columns.Add("Position") var_Column1.FormatColumn = "1 + ((1 rpos ``) contains `.`)" var_Column1.Visible = false var_ConditionalFormat = oG2antt.ConditionalFormats.Add("%C1") var_ConditionalFormat.BackColor = 16777216 /*0x1000000*/ var_ConditionalFormat.ChartBackColor = var_ConditionalFormat.BackColor var_Items = oG2antt.Items h = var_Items.AddItem("Group 1") var_Items.AddBar(var_Items.InsertItem(h,,"Child 1"),"Task",2001-01-03,2001-01-13) var_Items.AddBar(var_Items.InsertItem(h,,"Child 2"),"Task",2001-01-04,2001-01-14) var_Items.ExpandItem(h,true) h = var_Items.AddItem("Group 2") var_Items.AddBar(var_Items.InsertItem(h,,"Child 1"),"Task",2001-01-03,2001-01-13) var_Items.AddBar(var_Items.InsertItem(h,,"Child 2"),"Task",2001-01-04,2001-01-14) oG2antt.EndUpdate() |
2109 |
How can specify a black pattern for the task
OleObject oG2antt,var_Chart,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.DefaultItemHeight = 22 var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = 2001-01-01 var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,0) oG2antt.Columns.Add("Frames") var_Items = oG2antt.Items h = var_Items.AddItem("Task") var_Items.AddBar(h,"Task",2001-01-02,2001-01-12,"bar A") var_Items.ItemBar(h,"bar A",33,1) var_Items.AddBar(h,"Task",2001-01-14,2001-01-24,"bar B") oG2antt.EndUpdate() |
2108 |
Can I define a bar so it automatically fills the current item/row height (same height)
OleObject oG2antt,var_Chart,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Task") var_Chart = oG2antt.Chart var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,96) var_Chart.FirstVisibleDate = 2001-01-01 var_Chart.Bars.Item("Task").Height = -1 var_Items = oG2antt.Items var_Items.AddBar(var_Items.AddItem("Task A"),"Task",2001-01-02,2001-01-05) h = var_Items.AddItem("Task A") var_Items.AddBar(h,"Task",2001-01-02,2001-01-05,"") var_Items.ItemBar(h,"",33,255) oG2antt.EndUpdate() |
2107 |
How can I highlight a specified date for the entire chart (Method 2)
OleObject oG2antt,var_Chart,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Tasks") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = 2001-01-01 var_Chart.PaneWidth(false,96) var_Chart.UnitWidth = 18 var_Chart.LevelCount = 2 var_Chart.MarkTimeZone("zone1",2001-01-08,2001-01-09,0) var_Chart.MarkTimeZone("zone2",2001-01-02,2001-01-04,0,"50") var_Items = oG2antt.Items var_Items.AddItem("") h = var_Items.AddItem("Task(I)") var_Items.AddBar(h,"Task",2001-01-05,2001-01-12,"I") var_Items.AddItem("") oG2antt.EndUpdate() |
2106 |
How can I highlight a specified date for the entire chart, including the header (Method 1)
OleObject oG2antt,var_Chart,var_InsideZoomFormat,var_InsideZooms,var_Items any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Tasks") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = 2001-01-01 var_Chart.PaneWidth(false,96) var_Chart.UnitWidth = 18 var_Chart.LevelCount = 2 var_Chart.AllowInsideZoom = true var_Chart.AllowResizeInsideZoom = false var_Chart.InsideZoomOnDblClick = false var_InsideZoomFormat = var_Chart.DefaultInsideZoomFormat var_InsideZoomFormat.ForeColor = RGB(255,255,255) var_InsideZoomFormat.BackColorChart = RGB(0,0,1) var_InsideZoomFormat.BackColor = RGB(0,0,1) var_InsideZooms = var_Chart.InsideZooms var_InsideZooms.SplitBaseLevel = false var_InsideZooms.DefaultWidth = 18 var_InsideZooms.Add(2001-01-08).AllowInsideFormat = false var_Items = oG2antt.Items var_Items.AddItem("") h = var_Items.AddItem("Task(I)") var_Items.AddBar(h,"Task",2001-01-05,2001-01-12,"I") var_Items.AddItem("") oG2antt.EndUpdate() |
2105 |
How can I highlight a specified date of a specified item
OleObject oG2antt,var_Chart,var_Items,var_Note,var_Notes any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Tasks") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = 2001-01-01 var_Chart.PaneWidth(false,96) var_Chart.UnitWidth = 18 var_Chart.LevelCount = 2 var_Items = oG2antt.Items var_Items.AddItem("") h = var_Items.AddItem("Task(D)") var_Items.AddBar(h,"Task",2001-01-05,2001-01-12,"D") var_Items.AddItem("") var_Notes = oG2antt.Chart.Notes var_Note = var_Notes.Add("NoteD",h,2001-01-08,"<b><%dd%></b><br><%m%><br><%yy%>") var_Note.PartFixedWidth(1,18) var_Note.PartShadow(1,false) oG2antt.EndUpdate() |
2104 |
How can I display the start/end of the task within its margins (notes)
OleObject oG2antt,var_Chart,var_Items,var_Note,var_Note1,var_Notes any h oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Columns.Add("Tasks") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = 2001-01-01 var_Chart.PaneWidth(false,96) var_Chart.UnitWidth = 18 var_Chart.LevelCount = 2 var_Items = oG2antt.Items var_Items.AddItem("") h = var_Items.AddItem("Task(T)") var_Items.AddBar(h,"Task",2001-01-05,2001-01-12,"T") var_Items.AddItem("") var_Notes = oG2antt.Chart.Notes var_Note = var_Notes.Add("NoteTS",h,"T","") var_Note.ShowLink = 0 var_Note.PartText(0,"<%d%>") var_Note.PartHOffset(0,9) var_Note.PartFixedWidth(0,18) var_Note1 = var_Notes.Add("NoteTE",h,"T","") var_Note1.RelativePosition = "E-1" var_Note1.ShowLink = 0 var_Note1.PartText(0,"<%d%>") var_Note1.PartHOffset(0,9) var_Note1.PartFixedWidth(0,18) oG2antt.EndUpdate() |
2103 |
Is it possible to show the tasks not-overlaid when the item is collapsed and overlaid once the user expands the item
/*begin event BeforeExpandItem(long Item,any Cancel) - Fired before an item is about to be expanded (collapsed).*/ /* oG2antt = ole_1.Object oG2antt.Refresh() */ /*end event BeforeExpandItem*/ OleObject oG2antt,var_Bar,var_Chart,var_Items any h,h1 oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.Indent = 16 oG2antt.LinesAtRoot = -1 oG2antt.HasLines = 1 oG2antt.DrawGridLines = 1 oG2antt.Columns.Add("Tasks") var_Chart = oG2antt.Chart var_Chart.FirstVisibleDate = 2006-09-20 var_Chart.ShowCollapsedBars = true var_Chart.LevelCount = 2 var_Chart.PaneWidth(false,128) var_Chart.DrawGridLines = 1 var_Bar = var_Chart.Bars.Item("Task") var_Bar.OverlaidType = 3 var_Bar.Color = RGB(0,0,0) var_Bar.StartColor = RGB(196,196,196) var_Bar.EndColor = RGB(196,196,196) var_Bar.Pattern = 32 var_Items = oG2antt.Items h = var_Items.AddItem("Project 1") h1 = var_Items.InsertItem(h,,"Resources") var_Items.AddBar(h1,"Task",2006-09-21,2006-09-25,"A") var_Items.AddBar(h1,"Task",2006-09-24,2006-09-28,"B") var_Items.AddBar(h1,"Task",2006-09-27,2006-09-29,"C") h = var_Items.AddItem("Project 2") h1 = var_Items.InsertItem(h,,"Resources") var_Items.AddBar(h1,"Task",2006-09-21,2006-09-25,"A") var_Items.AddBar(h1,"Task",2006-09-24,2006-09-28,"B") var_Items.AddBar(h1,"Task",2006-09-27,2006-09-29,"C") var_Items.ExpandItem(h,true) oG2antt.EndUpdate() |
2102 |
Is it possible to display the label of the level without truncating / no clip
|
2101 |
How do I get the item's auto-number, when using FormatColumn property, as CellValue gets empty
/*begin event SelectionChanged() - Fired after a new item has been selected.*/ /* OleObject var_Items oG2antt = ole_1.Object var_Items = oG2antt.Items MessageBox("Information",string( "pos: " )) MessageBox("Information",string( var_Items.CellCaption(var_Items.FocusItem,1) )) MessageBox("Information",string( "rpos(1): " )) MessageBox("Information",string( var_Items.CellCaption(var_Items.FocusItem,2) )) MessageBox("Information",string( "rpos(2): " )) MessageBox("Information",string( var_Items.CellCaption(var_Items.FocusItem,3) )) MessageBox("Information",string( "apos: " )) MessageBox("Information",string( var_Items.CellCaption(var_Items.FocusItem,4) )) MessageBox("Information",string( "index: " )) MessageBox("Information",string( var_Items.CellCaption(var_Items.FocusItem,5) )) */ /*end event SelectionChanged*/ OleObject oG2antt,var_Column,var_Column1,var_Column2,var_Column3,var_Column4,var_Columns,var_Items any h,hSel oG2antt = ole_1.Object oG2antt.BeginUpdate() oG2antt.LinesAtRoot = -1 oG2antt.DrawGridLines = -2 oG2antt.HeaderAppearance = 4 var_Columns = oG2antt.Columns var_Columns.Add("Items") var_Column = var_Columns.Add("pos") var_Column.FormatColumn = "1 pos ``" var_Column.Position = 0 var_Column.Width = 48 var_Column.AllowSizing = false var_Column1 = var_Columns.Add("rpos(1)") var_Column1.FormatColumn = "1 rpos ``" var_Column1.Position = 1 var_Column1.Width = 48 var_Column1.AllowSizing = false var_Column2 = var_Columns.Add("rpos(2)") var_Column2.FormatColumn = "1 rpos `.||A-Z`" var_Column2.Position = 2 var_Column2.Width = 48 var_Column2.AllowSizing = false var_Column3 = var_Columns.Add("apos") var_Column3.FormatColumn = "1 apos ``" var_Column3.Position = 3 var_Column3.Width = 48 var_Column3.AllowSizing = false var_Column4 = var_Columns.Add("index") var_Column4.FormatColumn = "1 index ``" var_Column4.Position = 4 var_Column4.Width = 48 var_Column4.AllowSizing = false var_Items = oG2antt.Items h = var_Items.AddItem("Item 1") var_Items.InsertItem(h,,"Child 1") hSel = var_Items.InsertItem(h,,"Child 2") var_Items.ExpandItem(h,true) var_Items.AddItem("Item 2") var_Items.AddItem("Item 3") oG2antt.EndUpdate() oG2antt.Items.SelectItem(hSel,true) |